For example, you can compare two values of the same data type, such as DATE with DATE or TIMESTAMP with TIMESTAMP, but not of different data types, such as DATE with TIME or DATETIME with INTERVAL.

For example, you can create a check constraint that limits the values of a numeric column to a certain range, or that ensures that a date column is not in the future.

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw] This function returns the current database system timestamp as a datetime value, without the database time zone offset. CURRENT_TIMESTAMP derives ...