I made a job involves timestamp comparison but it keep give me Invalid Julian day error.
the job itself is nothing too special
and i am sure the problem is from this constraint
Code: Select all
NullToValue(Trx_Dim.P_TRANSACTION_TS, "2099-21-31-00.00.00.000000") <= Trx_Dim.DATE and NullToValue(Trx_Dim.C_TRANSACTION_TS, "2099-21-31-00.00.00.000000") <= Trx_Dim.DATE and NullToValue(Trx_Dim.S_TRANSACTION_TS, "2099-21-31-00.00.00.000000") <= Trx_Dim.DATE
cheers
abyss