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

    Sql code using UTC time and between



      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