October 21, 2015 at 12:00 am
Comments posted to this topic are about the item Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values
Gregory A. Larsen, MVP
October 21, 2015 at 6:34 am
Great article. I didn't know anything about the "...FROMPARTS" keywords.
October 21, 2015 at 9:43 am
Good article and could have used the DATEFROMPARTS function just yesterday (but I scripted a work around).
A good addition to this would be a discussion of whether or not T SQL can created a DATEFROMPARTS with leading zeros for 1 digit months and/or days.
October 22, 2015 at 10:44 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply