Time Data Type
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. Time must be set by specifying hours, minutes, and seconds.
MyTime := 0T; MyTime := 115900T; MESSAGE(FORMAT(MyTime)); MyTime := 115934T; MESSAGE(FORMAT(MyTime)); MyTime := 115934.444T; MESSAGE(FORMAT(MyTime)); MyTime := 235900T; MESSAGE(FORMAT(MyTime)); MyTime := 030000T; MESSAGE(FORMAT(MyTime));
The following shows what the message windows display accordingly on a computer with the regional format set to English (United States) for the syntax examples above.
Microsoft SQL Server stores information about both date and time in columns of the DATETIME type. Dynamics 365 uses only the time part and inserts a constant value for the date: 01-01-1754.
The Dynamics 365 undefined time is represented by the same value as an undefined date. The undefined date is represented by the earliest valid DATETIME in SQL Server, which is 01-01-1753 00:00:00:000.