Date Time conversion

Prasad Godbole

Hi ,

I am converting MM/dd/yyyy date to yyyy-MM-dd hh:mm:ss using dateobject.ToString("yyyy-MM-dd hh:mm:ss").

Its converting perfectly in given format but in MM-dd-yyyy format there is no hour specified and hour is appearing in this yyyy-MM-dd hh:mm:ss format .

For e.g. date is 05/07/2009 i.e. 7 May 2009 and after converting to yyyy-MM-dd hh:mm:ss format, date is appearing as 2009-05-07 12:00:00.

From where this 12 is appearing ? We don't want this 12 . The date should display like 2009-05-07 00:00:00.

Please suggest solution.

Thanks
Prasad

7 Replies

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

Jiteendra Sampathirao15y ago
Hi,
Go through these links:

http://www.sql-server-helper.com/tips/date-formats.aspx
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx
Jiteendra Sampathirao15y ago
Hi,

Do like this::

string @DOB = DateTime.ParseExact(txtDOB.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentUICulture. DateTimeFormat).ToString("MM/dd/yyyy");

Otherwise post the code here...
Abhimanyu K Vatsa15y ago
if you still find problem then provide us the code you are using, will try to find out the mistake.

thanks
Prasad Godbole15y ago
Hi all,

Thanks for giving solutions.

I used 24 hours date format and now hour is appearing 00.

Thanks again

Kind Regards
Prasad
Abhimanyu K Vatsa15y ago
read this msdn post, it probably will help you.

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
Vulpes15y ago
It's just struck me that the problem here is that you're using the 12 hour clock ("hh" format). If you change to the 24 hour format ("HH"), then it should get rid of the 12:00:00 i.e. dateobject.ToString("yyyy-MM-dd HH:mm:ss").
Vulpes15y ago
See if using dateobject.Date.ToString("yyyy-MM-dd hh:mm:ss") gets rid of the hour.