Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values RE: Stairway to Advanced T-SQL Level 8: Functions to Generating Date and Time values

  • October 22, 2015 at 10:44 am

    #1834974

    Love these topics.

    Did hit a syntax issue with this:

    SELECT SYSUTCDATETIME() AS "UTC Time",

    SYSDATETIME() AS "Local Time"

    DATEADD(HH,-7,SYSUTCDATETIME()) AS "Calculate Local Time";

    Needed a comma.