Date Expressions (M to SQL Mapping)

[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.]

These expressions are defined on Date, DateTime, and Time.

Operator	“M” Example	SQL Example
Addition	A + B	A + convert(datetime, B)
Equality	A == B	A = B
Inequality	A != B	A <> B
Relational	A <= B A >= B A < B A > B	A <= B A >= B A < B A > B

Exceptions

DateTime addition is not defined in “M” and is therefore not implemented.