Exercise

Parse strings to dates

Changing our language for data loading is not always feasible. Instead of using the SET LANGUAGE syntax, we can instead use the PARSE() function to parse a string as a date type using a specific locale.

We will once again use the dbo.Dates table, this time parsing all of the dates as German using the de-de locale.

Instructions

100 XP

Parse the input strings as dates using the German locale (de-de).
Then, parse the input strings as the data type DATETIME2(7), still using the German locale.

Take Hint (-30 XP)