1. Apprendre
    2. /
  2. Cours
    3. /
  3. Functions for Manipulating Data in SQL Server
Connected

Exercice

Changing the default language

The language set in SQL Server can influence the way character strings are interpreted as dates. Changing the language automatically updates the date format. In this exercise, you will analyze the impact of the SET LANGUAGE command on some practical examples. You will select between the English, Croatian, and Dutch language, taking into account that they use the following formats:

Language Date format
English mdy
Croatian ymd
Dutch dmy

Instructions 1/3

undefined XP
  • 1

    Change the language, so that '30.03.2019' is considered a valid date. Select the name of the month.

  • 2

    Change the language, so that '32/12/13' is interpreted as a valid date. Select the name of the month. Select the year.

  • 3

    Change the language, so that '12/18/55' is interpreted as a valid date. Select the day of week. Select the year.