Converting Number to Date

Question:
How do I convert a number that represents a date into a date field? The number’s format is CCYYMMDD.

Answer:
Fortunately, the format of your numeric value doesn’t need any modifications to save it to a date value. Assuming your numeric value is 20000710 for July 10, 2000, just use the CAST function:

DECLARE @DateVar datetimeset @DateVar = CAST('20000710' AS datetime)SELECT @DateVar AS DateValueDateValue                   --------------------------- 2000-07-10 00:00:00.000

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: