I have input like '2008-09-26T01:51:42.000Z' . what i need is to find ZoneID say 0 for Z . and changing That time to my local time. Also how come i know that z is 0 . i m really confused and help plz?.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
No one has followed this question yet.
SQL Server 2008 Date
Date Problem in SQl Server 2005
Please help: How to report next 6 months' rent
conversion of char data type to a datetime data type resulted in out-of-range
how to change the date format of sqlserver 2005