Replication Server supports four datatypes for date and time data:
datetime – dates and times of day between January 1, 1753 and December 31, 9999. Storage size is 8 bytes: 4 bytes for the number of days before or after the base date of January 1, 1900, and 4 bytes for the time, to 1/300 second. Dates before the base date are stored as negative values.
smalldatetime – dates and times of day between January 1, 1900 and June 6, 2079, with accuracy to one minute. Storage size is 4 bytes: one small integer for the number of days after January 1, 1900, and one small integer for the number of minutes since midnight.
date – dates between January 1, 0001, and December 31, 9999. Storage size is 4 bytes. Dates before the base date are stored as negative values.
time – time between 12:00:00 AM and 11:59:59.999 PM. Storage size is 4 bytes.
timestamp – uses varbinary(8) as the underlying datatype. A status bit differentiates timestamp from varbinary.
timestamp is propagated as timestamp to Replication Server 15.1 and as varbinary to Replication Server 15.0.1 or earlier.
Replication into a timestamp column is supported only
in ASE 15.0.2 or later.
