A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Datatypes: Date and Time Functions

time

The term time describes a datatype. This datatype requires four bytes of storage. The maximum and minimum values of the times to be stored, range between "12:00:00AM" and "11:59:59:999PM" with an accuracy of 1/300th of a second. The datatype time is available in ASE® starting with version 15.0.

Output of the datatype time

The output of the data can be formatted using the convert() function. Besides "0" ASE recognises a number of different time formats. When querying time fields should be specified in single or double quotes.

Date and Time; Functions and Commands of the Datatype time