|
date
The term date describes a
datatype.
This datatype requires four
bytes of
storage.
These four bytes are exclusively used to store dates.
The maximum and minimum values that can be stored ranges from "January 1, 0001" to "December 31, 9999". In order to store dates outside of this range of values the datatypes
char
or
varchar
must be defined The datatype date is available in
ASE®
starting with version 15.0.
Output of the datatype date
The output of the dates can be formatted using the
function
convert()
.
Except for "0" und "00/00/00",
ASE
recognises a large number of different date formats.
In a query, the date values should always be set within single or double quotes. Upper or lower case in date values is treated equally.
Date; Functions and commands of the datatype date
See also:
datetime,
Datetime Datatypes,
smalldatetime.
|
