Get startedGet started for free

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.

This exercise is part of the course

Time Series Analysis in SQL Server

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

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;
Edit and Run Code