Inserting ASE DATE and TIME type data [CR 442348]

12.6 ESD #9 supports inserting data from an Adaptive Server Enterprise database column of data type DATE or TIME using the INSERT...LOCATION syntax of the INSERT statement.

Add the following rows to Table 7-18: DATE/TIME data types in Chapter 7, “Moving Data In and Out of Databases.”

Adaptive Server Enterprise Datatype	Sybase IQ Datatype	Notes
date	date	You can insert data from an ASE database column of data type date using INSERT...LOCATION.
time	time	The Sybase IQ data type is the Time of day, containing hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places. A time value requires 8 bytes of storage. The Adaptive Server Enterprise data type time is between 00:00:00:000 and 23:59:59:999. You can use either military time or 12AM for noon and 12PM for midnight. A time value must contain either a colon or the AM or PM signifier. AM or PM may be in either uppercase or lowercase. A time value requires 4 bytes of storage. You can insert data from an ASE database column of data type time using INSERT...LOCATION.

Adaptive Server Enterprise Datatype

Sybase IQ Datatype

Notes

date

You can insert data from an ASE database column of data type date using INSERT...LOCATION.

time

The Sybase IQ data type is the Time of day, containing hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places. A time value requires 8 bytes of storage.

The Adaptive Server Enterprise data type time is between 00:00:00:000 and 23:59:59:999. You can use either military time or 12AM for noon and 12PM for midnight. A time value must contain either a colon or the AM or PM signifier. AM or PM may be in either uppercase or lowercase. A time value requires 4 bytes of storage.

You can insert data from an ASE database column of data type time using INSERT...LOCATION.