05_language_settings.sql

DECLARE @date1 NVARCHAR(20) = '30.03.2019';
-- Set the language
SET LANGUAGE 'Dutch';

SELECT
@date1 AS initial_date,
-- Check that the date is valid
ISDATE(@date1) AS is_valid,
-- Select the name of the month
DATENAME(MONTH, @date1) AS month_name;

GO

DECLARE @date1 NVARCHAR(20) = '12/18/55';
-- Set the language
SET LANGUAGE 'English';

SELECT
@date1 AS initial_date,
-- Check that the date is valid
ISDATE(@date1) AS is_valid,
-- Select the week day name
DATENAME(WEEKDAY, @date1) AS week_day,
-- Extract the year from the date
YEAR(@date1) AS year_name;

GO