Denotes a time ranging from 00:00:00.000 to 23:59:59.999. An undefined or blank time is specified by 0T.

The displayed text format of the time is determined by your Regional and Language Options in Windows.

The following are examples of valid assignments of times to a Time variable MyTime.

  CopyCode imageCopy Code
MyTime := 0T;
MyTime := 1159T;
MyTime := 115934T;
MyTime := 115934.444T;
MyTime := 0300T;

The following shows what the message windows display on a computer with the regional format set to English (United States).

11:59:00 AM

11:59:34 AM

11:59:34.444 AM

3:00:00 AM

Expand imageSQL Server Option

Expand imageSee Also