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);