I have a problem converting a datetime to the correct timezone. Our webserver his Regional and Language Options are: Regional Options: Dutch (Belgium) Advanced: English (United States) On this webserver there is an Indexing Service running on a DMS. When a
document is published or updated on the webserver his last modified time is correct. But when I run a query on the Indexing Service to retrieve the Write property it returns the time - 1. We have to set the Advanced language to English (United States) in order
to avoid errors when inserting data in our SQL Server which is also using the Advanced language, English (United States). The last thing has probally nothing to do with the problem, but just wanted to tell you. Can anybody help me on what I have to do at the
Indexing Service or Write property the Indexing Service returns before formatting it to the user his screen.
Try looking into Custom Formating the dates for your time zones, in SQL Server the Datatype ROWGUID will give you time and Currency by location. Take a look at the links below for pointers. Hope this helps. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstringsoutputexample.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp Kind regards, Gift Peddie
None
0 Points
19 Posts
Converting dates to correct timezone
Jan 21, 2005 07:50 AM|BSnyckers|LINK
Contributor
4150 Points
5249 Posts
Re: Converting dates to correct timezone
Jan 21, 2005 05:54 PM|Caddre|LINK