Post reply

The New Year 2023

  • December 30, 2022 at 12:00 am

    #4125256

    Comments posted to this topic are about the item The New Year 2023

  • December 30, 2022 at 12:06 pm

    #4131853

    Please update the hour part the answer options to 18:00 from 06:00 to match the question's time spec.  When someone runs the code they will see the day count difference between the two time zones.

    SELECT DATEDIFF(DAY, '1991-12-31 18:00:00 -5:00', '2023-01-01 00:00:00 -7:00') --11324 days

    SELECT DATEDIFF(DAY, '1991-12-31 18:00:00 -6:00', '2023-01-01 00:00:00 -7:00') --11323 days

    versus

    SELECT DATEDIFF(DAY, '1991-12-31 06:00:00 -5:00', '2023-01-01 00:00:00 -7:00') --11324 days

    SELECT DATEDIFF(DAY, '1991-12-31 06:00:00 -6:00', '2023-01-01 00:00:00 -7:00') --11324 days

    Happy New Year!

  • December 30, 2022 at 8:02 pm

    #4132046

    Ugh, silly typo. Fixed.

     

    my apologies

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

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