Date and time data types
282
DATETIME
DATETIME is provided primarily for compatibility with Adaptive Server
Enterprise.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise. For an
exception, see "Transact-SQL compatibility of string-to-date/time
conversions" on page 277.
"DATE data type" on page 281
"SMALLDATETIME data type" on page 282
"TIMESTAMP data type" on page 283
SMALLDATETIME data type [Date and Time]
A domain, implemented as TIMESTAMP.
SMALLDATETIME
SMALLDATETIME is provided primarily for compatibility with Adaptive
Server Enterprise.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise. For an
exception, see "Transact-SQL compatibility of string-to-date/time
conversions" on page 277.
"DATE data type" on page 281
"DATETIME data type" on page 281
"TIMESTAMP data type" on page 283
TIME data type [Date and Time]
The time of day, containing hour, minute, second and fraction of a second.
TIME
The fraction is stored to 6 decimal places. A TIME value requires 8 bytes of
storage. (ODBC standards restrict TIME data type to an accuracy of seconds.
For this reason you should not use TIME data types in WHERE clause
comparisons that rely on a higher accuracy than seconds.)
♦
SQL/92 Vendor extension.
Syntax
Usage
Standards and
compatibility
See also
Function
Syntax
Usage
Standards and
compatibility
See also
Function
Syntax
Usage
Standards and
compatibility
To Next Page
Loading...