DateTimeOffset Literals ("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.]
DateTimeOffset literals are used to write a time of day on a specific date in a specific time zone. DateTimeOffset literals are similar to ISO 8601; ‘0001’ is the representation of 1 AD; there is no year 0, and ‘0000’ is not a valid lexical representation; ‘-0001’ is the representation of 1 BC. The type of a DateTimeOffset literal is DateTimeOffset.
Literal Format
DateTimeOffset literals take the following format.
DateTimeOffset literal:
DateTimeOffset = Date "T" Time TimeZone;
token TimeZone
= Sign TimeHourMinute
| "Z";