Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Date Functions

Date Functions

SQL Server 2000

Date functions are used to display information about dates and times. These functions manipulate datetime and smalldatetime values, performing arithmetic operations on them. Date functions can be used anywhere an expression can be used.

SQL Server recognizes a wide variety of datetime data entry formats. You can use the SET DATEFORMAT statement to set the order of the dateparts (month/day/year) for entering datetime or smalldatetime data. Enclose datetime or smalldatetime values in single quotation marks.

See Also

Date and Time Functions

© 2015 Microsoft