Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

Great article. I didn't know anything about the "...FROMPARTS" keywords.

cjackson 63531 Valued Member Points: 52 More actions · Answer 2

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.

Thanks.

C Jackson

mspurlock Valued Member Points: 65 More actions · Answer 3

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.