Post reply

SQL Server time error

  • August 31, 2004 at 8:23 am

    #86361

     

    Hello;

    We use SQL Server 2000 Enterprise Edition SP3.When i using query anlyzer on the dbo.docs i find our documents but timecreated is wrong.For example; i create XXX.doc time is different windows time.All document's time 3 hours ago. What can i do?

     

    Thanks for your help...

  • August 31, 2004 at 8:43 am

    #521237

    How do you create the documents? Your application may set timr in different zone than your server setting.

  • August 31, 2004 at 10:55 am

    #521260

    Is there a trigger or script that could be saving the time as UTC (GMT)? The command GETUTCDATE() might be in use with your database.

    Quick way to figure out if this might be the issue - what time zone are you in? Compare that to GMT - is it a three hour difference? If so, then most likely something in your script or database is converting local time to UTC (GMT).

    -SQLBill

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply