locked
Converting dates to correct timezone RRS feed

  • Question

  • User-292337603 posted
    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.
    Friday, January 21, 2005 7:50 AM

All replies

  • User1416329745 posted
    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
    Friday, January 21, 2005 5:54 PM