|
smalldatetime
The term smalldatetime describes a
datatype.
Like all
datetime datatypes
the datatype smalldatetime is also an extension to
Transact-SQL
It requires four
bytes
of
storage.
The maximum and minimum values of the dates to be stored ranges from
"Januar 1, 1900" to
"June 6, 2079" with an accuracy of one minute.
Depending on specific requirements dates outside of this range of values the datatypes
datetime,
char
or
varchar
must be defines.
Output of the datatype smalldatetime
The
ASE-Server
recognises, stores and manipulates date and time values seperately in the datatype smalldatetime.
This means that time can be displayed before or after a date. The data
output can be formated with the help of the
convert()
function.
Date and Time; Functions and Commands
See also:
date,
datetime,
Datetime Datatypes.
|
