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