Category: ASE: Datatypes: Datetime Datatypes

datetime

The term datetime describes a datatype. Like all datetime datatypes the datatype datetime is also an Transact-SQL extention. It requires eight bytes of storage. Out of these eight bytes, four bytes are used to store the date and four bytes are used to store time values. The maximum and minimum values of the dates to be stored range from "January 1, 1753" to "December 31, 9999" with a precision of 1/300th of a second. For dates outside of this range of values, the datatypes char or varchar have to be defined.

Output of the datatype datetime

For the datatype datetime ASE-Server recognises, stores and manipulates date and time seperately. This means that time can be displayed before or after the date. The output can be converted using the function convert() .

Date and time; functions and commands of the datatype datetime

• convert()
• dateadd()
• datediff()
• datename()
• datepart()
• getdate()
• year()
• month()
• day()
• set datefirst
• set dateformat

See also:

date,
Datetime Datatypes,
smalldatetime.