SQLzoo.net

Date and time types.

Sybase
The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose.	Run the tidy code silently CREATE TABLE t_dttest( a DATE, b TIME, c DATETIME); INSERT INTO t_dttest VALUES ( '1962-05-20', '10:32:16', '1962-05-20 10:32:16'); SELECT * FROM t_dttest;
Specific to Sybase
Use DATETIME in place of TIMESTAMP. Use simple strings for DATE literals.