Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    17

    Unanswered: Insert Date/Time Issue

    Hi everyone,

    Today while testing my insert SQL for my Access DB I notice after the insert was applied it inserted the time 1 hour behind. I applied all the updates Microsoft offered and my clock in the lower right corner is the correct time..... How could this be????

    Could this be a serious issue that has not been addressed yet.. It seems like they just changed the clock down in the lower left to look an hour ahead but the internals are still off an hour....

    Any thoughts on this?

    I just figured I post this topic to get everyones thoughts..

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sounds suspisciously like a summer time issue to me
    it could be a regional settings issue
    what is the data being stored on, and is the time on that device different.. eg if you are using a server backend is it possible that that device's clock is incorrect?

    glad that in jolly old blighty we aren't tinkering with the start date at short notice.. still got 2 weeks to go I think
    Last edited by healdem; 03-13-07 at 12:47.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2006
    Posts
    17
    Yes that is the case our server at work was never updated.. Right after I wrote this topic I logged into the server and checked the time..

    thx

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Damn, beaten to the DST answer!
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •