I want to store and retrieve datetime in ISO 8601 format:
'2007-06-02T16:12:08.123-04:34'
or
'2007-06-02T16:12:08.123Z'
When I insert a datetime with SQL Server Management Studio and then I do a
SELECT I loose original "string" and the datetime get converted in a local
datetime.
Suppose I have an handheld in NY and another in Athens, the DB server in
Moscow and the front end application that sees DB data in Rome.
My handheld app stores ISO 8601 datetime into an XML file and send it to the
DB server through a Web Service.
I'd like the user in Rome to see datetimes on a datagrid all with Rome time
zone or with originals timezones or as a string in ISO 8601 format.
How to do that?
I've converted all datetimes to UTC and then stored them without the
trailing Z so that the DB does not convert them.
Can I add a column with the UTC offset to recreate original datetimes or the
overhead before displaying the dataset is too much?
Thanks,
Luigi.