Blog related to Microsoft Dynamics AX
Showing posts with label
UTC
.
Show all posts
Showing posts with label
UTC
.
Show all posts
Monday, February 21, 2011
Handling AX UTC dates in SQL Server
SELECT *, DATEADD(hour,DATEDIFF(hour,GETUTCDATE(),GETDATE()),MODIFIEDDATETIME) As ModifiedDateTime from SYSRECORDLEVELSECURITY
Older Posts
Home
Subscribe to:
Posts (Atom)