ASA SQL Reference
  SQL Data Types

Date and time data types

Function 

For storing dates and times.

Sending dates and times to the database
Retrieving dates and times from the database
Comparing dates and times in the database
Using unambiguous dates and times
DATE data type [Date and Time]
DATETIME data type [Date and Time]
SMALLDATETIME data type [Date and Time]
TIME data type [Date and Time]
TIMESTAMP data type [Date and Time]