Category: ASE: Functions: Date and Time Functions

Date and Time Functions

Date & Time Functions are used to convert the datatypes datetime, smalldatetime, date and time .

Usage of Date & Time Functions

The functions are used in Queries in a select-statement or wherever so-called "expression" are allowed and can be used, as well as in where clauses. The datatype datetime can only be used, if the date to be displayed lies after 1. Januar 1753. The values must either be set within single or double quotes or an error message will be returned. The datatype data can be used for values in the range between 0001.01.01 and 9999.01.01. Its values also must be set within single or double quotes. For all date values prior to teh values above, the datatypes char, nchar, varchar or nvarchar can be used.

List of ASE Date and Time Functions

ASE® provides a number of date and time functions:

• convert (see also: Style-numbers)
• dateadd()
• datediff()
• datename()
• datepart()
• getdate()
• year()
• month()
• day()

See also:

ASE T-SQL - Aggregate Functions,
dateadd(),
datediff(),
datename(),
datepart(),
date_part,
day(),
getdate(),
month(),
style numbers,
year().