Skip to content

Latest commit

 

History

History
105 lines (83 loc) · 3.51 KB

datefirst-transact-sql.md

File metadata and controls

105 lines (83 loc) · 3.51 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
@@DATEFIRST (Transact-SQL)
@@DATEFIRST (Transact-SQL)
markingmyname
maghan
09/18/2017
sql
t-sql
reference
DATE_FORMAT_TSQL
DATE FORMAT
@@DATEFIRST_TSQL
@@DATEFIRST
dates [SQL Server], functions
date and time [SQL Server], SET DATEFIRST
first day of week [SQL Server]
dates [SQL Server], first day of week
day of week [SQL Server]
SET DATEFIRST option [SQL Server]
date and time [SQL Server], DATEFIRST
DATEFIRST option [SQL Server]
date and time [SQL Server], @@DATEFIRST
weekdays [SQL Server]
@@DATEFIRST function [SQL Server]
functions [SQL Server], date and time
options [SQL Server], date
TSQL
>= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric

@@DATEFIRST (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]

This function returns the current value of SET DATEFIRST, for a specific session.

See Date and Time Data Types and Functions (Transact-SQL) for an overview of all [!INCLUDEtsql] date and time data types and functions.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@DATEFIRST

Return Type

tinyint

Remarks

SET DATEFIRST n specifies the first day (SUNDAY, MONDAY, TUESDAY, etc.) of the week. The value of n ranges from 1 to 7.

SET DATEFIRST 3;
GO  
SELECT @@DATEFIRST; -- 3 (Wednesday)
GO

For a U.S. English environment, @@DATEFIRST defaults to 7 (Sunday).

This language setting impacts character string interpretation as SQL Server converts those strings to date values for database storage. This setting also impacts display of date values stored in the database. This setting does not impact the storage format of date data.

This example first sets the language to Italian. The statement SELECT @@DATEFIRST; returns 1. The next statement sets the language to is then set to us_english. The final statement, SELECT @@DATEFIRST; returns 7.

SET LANGUAGE Italian;  
GO  
SELECT @@DATEFIRST;  
GO  
SET LANGUAGE us_english;  
GO  
SELECT @@DATEFIRST;

Examples

This example sets the first day of the week to 5 (Friday), and assumes that the current day, Today, falls on Saturday. The SELECT statement returns the DATEFIRST value and the number of the current day of the week.

SET DATEFIRST 5;  
SELECT @@DATEFIRST AS 'First Day'  
    ,DATEPART(dw, SYSDATETIME()) AS 'Today';

[!INCLUDEssResult]

First Day         Today  
----------------  --------------  
5                 2

Example

[!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]

SELECT @@DATEFIRST;

See also

Configuration Functions (Transact-SQL)