Converting UTC time to String
-
I am attempting to convert a UTC time into a normal date and time using a dataset and the dataset's .GetXML() method. I currently have the following UTC Time: 2004-08-16T16:30:54.0000000-05:00 I would like it to display as: 8/16/2004 4:30:54 PM This is so that when I create an Excel file through XSLT, I can set the column type to Date and then have a date that is User Friendly. Thanks for any help that can be provided.
-
I am attempting to convert a UTC time into a normal date and time using a dataset and the dataset's .GetXML() method. I currently have the following UTC Time: 2004-08-16T16:30:54.0000000-05:00 I would like it to display as: 8/16/2004 4:30:54 PM This is so that when I create an Excel file through XSLT, I can set the column type to Date and then have a date that is User Friendly. Thanks for any help that can be provided.
Daytime, Internet Time Service Class By Alastair Dallas http://www.thecodeproject.com/vb/net/daytime.asp