Example
Return the year part of a date:
SELECT YEAR('2017/08/25') AS Year;
Definition and Usage
The YEAR() function returns the year part for a specified date.
Syntax
YEAR(date)
SQL SYSDATETIME Function
Example
Return the date and time of the SQL Server:
SELECT SYSDATETIME() AS SysDateTime;
Definition and Usage
The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.
Syntax
SYSDATETIME()
SQL MONTH Function
Example
Return the month part of a date:
SELECT MONTH('2017/08/25') AS Month;
Definition and Usage
The MONTH() function returns the month part for a specified date (a number from 1 to 12).
Syntax
MONTH(date)
SQL ISDATE Function
Example
Check if the expression is a valid date:
SELECT ISDATE('2017-08-25');
Definition and Usage
The ISDATE() function checks an expression and returns 1 if it is a valid date, otherwise 0.
Syntax
ISDATE(expression)
SQL GETUTCDATE Function
Example
Return the current UTC date and time:
SELECT GETUTCDATE();
Definition and Usage
The GETUTCDATE() function returns the current database system UTC date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Syntax
GETUTCDATE()
SQL GETDATE Function
Example
Return the current database system date and time:
SELECT GETDATE();
Definition and Usage
The GETDATE() function returns the current database system date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Tip: Also look at the CURRENT_TIMESTAMP function.
Syntax
GETDATE()
SQL DAY Function
Example
Return the day of the month for a date:
SELECT DAY('2017/08/25') AS DayOfMonth;
Definition and Usage
The DAY() function returns the day of the month (from 1 to 31) for a specified date.
Syntax
DAY(date)
SQL DATEPART Function
Example
Return a specified part of a date:
SELECT DATEPART(year, '2017/08/25') AS DatePartInt;
Definition and Usage
The DATEPART() function returns a specified part of a date.
This function returns the result as an integer value.
Syntax
DATEPART(interval, date)
SQL DATENAME Function
Example
Return a specified part of a date:
SELECT DATENAME(year, '2017/08/25') AS DatePartString;
Definition and Usage
The DATENAME() function returns a specified part of a date.
This function returns the result as a string value.
Syntax
DATENAME(interval, date)
SQL DATEFROMPARTS Function
Example
Return a date from its parts:
SELECT DATEFROMPARTS(2018, 10, 31) AS DateFromParts;
Definition and Usage
The DATEFROMPARTS() function returns a date from the specified parts (year, month, and day values).
Syntax
DATEFROMPARTS(year, month, day)