Takes actual time stamp value and expected time stamp value, checks that actual value is greater than expected value and report failure if actual value is less or equal to expected value. 

Note:

Oracle used DBTD_ASSERT_DT_IS_GRTR name for this assert procedure because of character limit for object names.

Arguments

  • V_ActualValue - actual value, Datetime.
  • V_ExpectedValue - expected value, Datetime.
  • v_UserMessage – message to report when assertion fails, Variable Character (255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server.

 

Examples

SQL Server

      EXEC DBTD_ASSERT_DATETIME_IS_GREATER ‘2012-05-01’, ’1999-01-01’, ‘Values should be greater than expected’;

Oracle

      DBTD_ASSERT_DATETIME_IS_GREATER (‘2012-05-01’, ’1999-01-01’, ‘Values should be greater than expected’);

Netezza

      CALL DBTD_ASSERT_DATETIME_IS_GREATER (‘2012-05-01’, ’1999-01-01’, ‘Values should be greater than expected’);

 

See Also