Date and Time Functions (T-SQL)

These scalar functions perform an operation on a date and time input value and return either a string, numeric, or date and time value.

DATEADD DAY
DATEDIFF GETDATE
DATENAME MONTH
DATEPART YEAR

See Also

Functions

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.