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