DateTime Formating

[sudip]

I hav a log.txt file which contains following DateTime format > Fri May 06
18:05:54 GMT+05:30 2005 . so plzz help me how to accept this format & update
in my DataBase, so that my webapplication DataGrid can display above DateTime
format.

[Tom Porterfield]

On Fri, 6 May 2005 07:40:05 -0700, sudip wrote:

I hav a log.txt file which contains following DateTime format > Fri May 06
18:05:54 GMT+05:30 2005 . so plzz help me how to accept this format & update
in my DataBase, so that my webapplication DataGrid can display above DateTime
format.

string str = "Fri May 06 18:05:54 GMT+05:30 2005";
DateTime dt = DateTime.ParseExact(str, "ddd MMM dd HH:mm:ss 'GMT'zzz yyyy",
DateTimeFormatInfo.CurrentInfo);

Should do it.
--
Tom Porterfield

[sudip]

Hi Tom
Thanks a ton for the mail, it has really helped me to read the DateTime from
the log.text file , but how do update this format into my SQL database coz in
my database table there is a Column named "DateTimeIn" which is unable accept
this
format > Fri May 06 18:05:54 GMT+05:30 2005.

Thanx !!


"Tom Porterfield" wrote:

On Fri, 6 May 2005 07:40:05 -0700, sudip wrote:

I hav a log.txt file which contains following DateTime format > Fri May 06
18:05:54 GMT+05:30 2005 . so plzz help me how to accept this format & update
in my DataBase, so that my webapplication DataGrid can display above DateTime
format.

string str = "Fri May 06 18:05:54 GMT+05:30 2005";
DateTime dt = DateTime.ParseExact(str, "ddd MMM dd HH:mm:ss 'GMT'zzz yyyy",
DateTimeFormatInfo.CurrentInfo);

Should do it.
--
Tom Porterfield