How can I get a date in yyyy-mm-dd format (2013-10-25) in

Question

I am writing a API client Wrapper for C# where I have to implement an interface which accepts the date as an DateTime object in 'yyyy-mm-dd' format. What I have tried: I have looked for lot of solutions but couldn't find one. It can be achieved by converting the DateTime to string but I need it as DateTime object only. With Parse and ParseExact it gives output which include time 00:00:00 also, but the requirement is only to ger 'yyyy-mm-dd' format as DateTime object. Can someone please help?? Thanks in Advance

Amit Gupta · Answer

I don't think you will get only Date as DateTime object, it consists of both date & time. If you need only date then tge result you get is in string only otherwise you will get default time format included in it

Rahul Kashyap · Answer

DateTime date = DateTime.ParseExact(txtChqDate.Text, "yyyy-mm-dd", CultureInfo.InvariantCulture);

warner jonn · Answer

Convert your string to DateTime and then use DateTime.ToString("yyyy-MM-dd") DateTime dt= DateTime.ParseExact(inDate, "dd-MM-yyyy", CultureInfo.InvariantCulture); string str = dt.ToString("yyyy-MM-dd"); More on C# DateTime: http://csharp.net-informations.com/language/date.htm

Kapil Gaur · Answer

Amit is right. If you want some formatted date then you will get in string form only else DateTime object is having date and time both. When you do DateTime.Date => an string. You can anyway format DateTime.ToString() to the format you want.

Suraj Kumar · Answer

declare @Dt date set @Dt = GETDATE() select @Dt as 'Only Date' If you declare your data type as Date in table then you will automatically get date only. Check this

Rajeesh Menoth · Answer

Hi Amit, Please refer the following thread : https://stackoverflow.com/questions/1438045/c-sharp-best-way-to-convert-string-date-format-to-another-string

Amit Joshi · Answer

Hi Suraj, Down vote because your solution returns date as string and I need it as DateTime object as I have clearly mentioned in question.

Suraj Kumar · Answer

I am again casting varchar to date using convert so the output will be date not the string. You can use Convert in C# also.

Amit Joshi · Answer

Hi Kalyani, It's throwing Exception.... https://www.screencast.com/t/6J6bBofo

Suraj Kumar · Answer

Any reason of down vote?

Kalyani Shevale · Answer

try this code string DateString = "11/12/2009" ; IFormatProvider culture = new CultureInfo( "en-US" , true ); DateTime dateVal = DateTime.ParseExact(DateString, "yyyy-MM-dd" , culture);

Amit Joshi · Answer

This solution gives the date as String, but my problem is - I want it as DateTime object with format yyyy-mm-dd.

Suraj Kumar · Answer

You can acheive using SQL Server as shown below select Convert ( Date , convert ( varchar , getdate(), 23)) You can also get it using C#, check the below post https://www.c-sharpcorner.com/blogs/date-and-time-format-in-c-sharp-programming1