4 Replies Latest reply on Jul 18, 2013 4:45 PM by jcorcoran

    Sql code using UTC time and between

    jcorcoran

       

      You can see that this string is related to the date and its referencing UTC , in the BETWEEN syntax ... do you know what those numbers represent ?

       

      ( DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()) , AuditingEvents.TimeLoggedUtc) BETWEEN 41105 AND 41471 )

       

       

      what are these numbers 

                                    V                 V

      BETWEEN 41105 AND 41471