Date and Time Datatypes

Use datetime, smalldatetime, bigdatetime, bigtime, date, and time to store absolute date and time information. Use timestamp to store binary-type information.

SAP ASE has various datatypes used to store date and time values.

The default display format for dates is “Apr 15 1987 10:23PM”. bigdatetime/bigtime types have a default display format of “Apr 15 1987 10:23:00.000000PM” You can use the convert function for other styles of date display. You can also perform some arithmetic calculations on date and time values with the built-in date functions, though the SAP ASE server may round or truncate millisecond values.

When entering date and time information, always enclose the time or date in single or double quotes.