Time is an hour out!!!

  • I think that this is likely related to the rescent change in my timezone from BST to GMT on Sunday but I suspect that the postings are showing as an hour later than it actually in.

    As an example: post (http://www.sqlservercentral.com/Forums/Topic1801329-263-1.aspx#bm1830865):

    When using Firefox: Posted Today @ 2:44:18 PM

    When using IE: Posted Today @ 7:44 AM

    Local time: 14:18

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • May be a browser issue. I just don't know.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Go to the forum settings http://www.sqlservercentral.com/Forums/EditForumSettings.aspx

    And all the way down, there are the date and time settings. Check that you have the correct timezone and play with the checkbox that says "Observe Daylight Saving Time (If time appears an hour out, check or uncheck to suit)"

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (11/1/2016)


    Go to the forum settings http://www.sqlservercentral.com/Forums/EditForumSettings.aspx

    And all the way down, there are the date and time settings. Check that you have the correct timezone and play with the checkbox that says "Observe Daylight Saving Time (If time appears an hour out, check or uncheck to suit)"

    It says:

    All times are GMT, Time now is 4:29pm

    WRONG!!! GMT/UTC was 3:29pm at the time.

    I tried unchecking "Observe Daylight Saving Time (If time appears an hour out, check or uncheck to suit)" and clicking Update to see if it made a difference but it remained checked.

    Thanks for the attempted assist Luis.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Tried the checkbox again. I could change it this time but to no avail.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Strange. The server time is still MST, so it's 9:56am as post this, in Denver, which should be 3:56 BST.

  • Steve Jones - SSC Editor (11/1/2016)


    Strange. The server time is still MST, so it's 9:56am as post this, in Denver, which should be 3:56 BST.

    Yep, it was 3:56pm, but the forum says you posted it at 4:56pm and the settings page says:

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • It's been like this for several years now. It's always an hour out between when the clocks in Europe change and when those in the USA change. So on Sunday (6th November), the clocks go back in America and everything will be back to normal.

    John

  • Ooops - double post.

  • I am going to assume that John is correct and mark as solution. It is not a significant problem. Had it been a financial transaction...nope just a forum. We can live with this one (or, at least, I can).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • I think this is because this version of the forum is old, prior to the date changes for DST. Right now, the UK has moved back to standard, but the US hasn't.

    I think this will be fixed next week, but as you note, this isn't a bit deal for forums.

  • Viewing 11 posts - 1 through 10 (of 10 total)

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