Oct 30, 2007 · Transact-SQL reference for the DATEPART function. This function returns an integer corresponding to the datepart of a specified date.

Returns an integer that represents the year of the specified date. For an overview of all Transact-SQL date and time data types and functions, see Date and Time Data Types and Functions (Transact-SQL).

Functions that return system date and time values Transact-SQL derives all system date and time values from the operating system of the computer on which the instance of SQL Server runs.

DATEFROMPARTS returns a date value, with the date portion set to the specified year, month and day, and the time portion set to the default. For invalid arguments, DATEFROMPARTS will raise an error.

This function adds a number (a signed bigint) to a datepart of an input date, and returns a modified date/time value. For example, you can use this function to find the date that is 7,000 minutes from …

Transact-SQL reference for the DATEDIFF function. Returns the numerical difference between a start and end date based on datepart.

Referência de Transact-SQL para a função DATEPART. Essa função retorna um inteiro correspondente à datepart de uma data especificada.

Returns an integer that represents the month of the specified date. For an overview of all Transact-SQL date and time data types and functions, see Date and Time Data Types and Functions (Transact-SQL).

Referencia de Transact-SQL para la función DATEPART. Esta función devuelve un entero que se corresponde con el parámetro datepart de una fecha especificada.

Oct 30, 2007 · Arguments datepart The specific part of the date argument that DATENAME will return. This table lists all valid datepart arguments.