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.
Questo esercizio fa parte del corso
Time Series Analysis in SQL Server
Istruzioni dell'esercizio
- Parse
DateTextas dates using the German locale (de-de). - Then, parse
DateTextas the data typeDATETIME2(7), still using the German locale.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT
d.DateText AS String,
-- Parse as DATE using German
___(d.___ AS DATE USING ___) AS StringAsDate,
-- Parse as DATETIME2(7) using German
___(d.___ AS DATETIME2(7) USING ___) AS StringAsDateTime2
FROM dbo.Dates d;