DateTime Type ("M" Reference)

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

The DateTime type encompasses any calendar date and time zone value with the format shown in the Code Example section.

Operators

The binary operations in the following table take DateTime as a left operand.

Operator Right Operand Return

>, <, <=, >=, ==, !=

DateTime

Logical

Code Example

The following code shows the Departure field being declared as a DateTime type and receiving the value of 2005-10-5T04:34:32.

Departure : DateTime = 2005-10-5T04:34:32;