Year 2000 compliance
298
Data type Contains Stored in Range of
possible
values
DATE Calendar date
(year, month, day)
4-bytes 0001-01-01 to
9999-12-31
TIMESTAMP Time stamp (year,
month, day, hour
minute, second,
and fraction of
second accurate to
6 decimal places)
8-bytes 0001-01-01 to
9999-12-31
(precision of the
time portion of
TIMESTAMP is
dropped prior to
1600-02-28
23:59:59 and
after 7911-01-01
00:00:00)
$ For more information on Adaptive Server Anywhere date and time data
types see "Date and time data types" on page 277.
Sending and retrieving date values
Date values are stored within Adaptive Server Anywhere as either a DATE
or TIMESTAMP data type, but they are passed to and retrieved from
Adaptive Server Anywhere using one of the following methods:
♦ As a string, using any Adaptive Server Anywhere programming
interface.
♦ As a TIMESTAMP structure, using ODBC.
♦ As a SQLDATETIME structure, using Embedded SQL.
A string containing a date value is considered unambiguous and is
automatically converted to a DATE or TIMESTAMP data type without
potential for misinterpretation if it is passed using the following format:
yyyy-mm-dd (the "-" dash separator is one of several characters that are
permitted).
Date formats other than yyyy-mm-dd can be used by setting the
DATE_FORMAT database option. For more information, see
"DATE_FORMAT option" on page 181.
For more information on unambiguous date formats, see "Using
unambiguous dates and times" on page 279.
For more
information
To Next Page
Loading...