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

Amit Joshi

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

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta7y ago
Accepted 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
warner jonn6y ago
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 Gaur7y ago
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 Kumar7y ago
1. declare @Dt date
2. set @Dt = GETDATE()
4. select @Dt as 'Only Date'
If you declare your data type as Date in table then you will automatically get date only. Check this

Rahul Kashyap7y ago

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

Rajeesh Menoth7y ago

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 Joshi7y ago

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 Kumar7y ago

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 Joshi7y ago

Hi Kalyani,

It's throwing Exception....

https://www.screencast.com/t/6J6bBofo

Suraj Kumar7y ago

Any reason of down vote?

Kalyani Shevale7y ago

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 Joshi7y ago

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

Suraj Kumar7y ago

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