datetime conversion

Question

Hi All,

I want to convert any current datetime (differs in format depending regional setting) into 20090622172120 format.
How do I do that? I want solution that work with any regional setting.

many thanks,

Jeet

Trifon Dinev · Answer

Hi for yyyymmddhms public static string GetMySQLDate( string date) { DateTime dat = new DateTime (); dat = Convert .ToDateTime(date); string mysqld; mysqld = dat.Year.ToString() + "." + dat.Month.ToString() + "." + dat.Day.ToString() + " " + dat.Hour.ToString() + ":" + dat.Minute.ToString() + ":" + dat.Second.ToString(); return mysqld; } for vice versa public static string GetNormalLDate( string date) { DateTime dat = new DateTime (); dat = Convert .ToDateTime(date); string normalsqld; mysqld = dat.Day.ToString() + "." + dat.Month.ToString() + "." + dat.Year.ToString() + " " + dat.Hour.ToString() + ":" + dat.Minute.ToString() + ":" + dat.Second.ToString(); return normalsqld; } I hope this is what you are looking for.

jeet p · Answer

Hi Manish Thanks for your correct problem, but now issue is that I want this value should be formatted back in original datestring. how? thanks Jeet

Manish Dwivedi · Answer

Hi , Try this DateTime.Now.ToString("yyyyMMddHHmmss");

datetime conversion

Answers (3)