Dynamics AX

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
Posted by kiwiaxguy at 2:30 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Dynamics AX, SQL Server, UTC
Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Blog Archive

  • ▼  2017 (1)
    • ▼  February (1)
      • Vendor email address list from AX 2012 R3
  • ►  2016 (3)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2015 (7)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2014 (8)
    • ►  September (2)
    • ►  July (4)
    • ►  June (2)
  • ►  2013 (2)
    • ►  November (1)
    • ►  October (1)
  • ►  2012 (1)
    • ►  May (1)
  • ►  2011 (11)
    • ►  April (5)
    • ►  March (2)
    • ►  February (4)

About Me

Microsoft Communities

Microsoft Dynamics Communities

Labels

  • AIF (2)
  • ASYNC Service (1)
  • Create document service wizard (1)
  • Data Migration (1)
  • default dimension (1)
  • Dynamics AX (7)
  • Dynamics AX 2009 (1)
  • Dynamics AX 2012 (9)
  • Dynamics AX 2012 R3 for RETAIL (1)
  • Dynamics AX 4.0 (1)
  • Forms (2)
  • IIS (1)
  • LedgerDimension (1)
  • Master Planning (1)
  • OLAP (1)
  • Purchase Orders (1)
  • SQL (3)
  • SQL Server (5)
  • SQL2005 (1)
  • SysQueryForm (1)
  • Tax (1)
  • UTC (1)
  • Web services (2)
  • X++ (8)

AX Add-On Links

  • Axtension

Other Links

  • C# Programming
  • Source code formatter for Blogspot

Dynamics AX Links

  • AX Blogs
  • Axaptapedia
  • MSDN
  • Microsoft Dynamics AX Design Patterns
  • Microsoft Dynamics AX for Retail
  • The Microsoft Dynamics AX product team blog

Enterprise Portal links

  • EP Quick Start
  • EP Screen casts
  • EP SDK
  • EP team blog
  • Solution Monkey blog
Picture Window theme. Powered by Blogger.