Assert procedure that takes actual and expected DATE values, compares them for equality and report failure if they are not equal

Note: If actual or expected, or both values are NULL then assert will fail. 

Arguments

  • v_ActualValue - actual value, DATE
  • v_ExpectedValue - expected value, DATE
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)

 

Examples

SQL Server

      EXEC DBTD_ASSERT_DATE_ARE_EQUAL '2013/01/01', '2013-01-03', ‘Values should be the same’;

 

See Also