Timestamp value comparision in transformer
Posted: Sat Jul 26, 2008 2:18 am
Hi,
I have requirement like this
i need to make a look up between hashfile which has one of the output column as Timestamp(Column name Start_date) and A table which has one of the output column as Timestamp(Begin_date).This output is generated by User defined SQL. Iam using To_Date and To_Char functions to bring the date column in to Timestamp format.
i have converted Begin_date with to_date to format YYYY-MM-DD HH24:MI:SS. iam getting error as Timestamp conversion unsuccessfull
In the transformer i need to check for constraint Start_date > Begin_Date
Can somenody help me on this .
Please ask me if u need some more details on problem description
Thanks,
Prasad
I have requirement like this
i need to make a look up between hashfile which has one of the output column as Timestamp(Column name Start_date) and A table which has one of the output column as Timestamp(Begin_date).This output is generated by User defined SQL. Iam using To_Date and To_Char functions to bring the date column in to Timestamp format.
i have converted Begin_date with to_date to format YYYY-MM-DD HH24:MI:SS. iam getting error as Timestamp conversion unsuccessfull
In the transformer i need to check for constraint Start_date > Begin_Date
Can somenody help me on this .
Please ask me if u need some more details on problem description
Thanks,
Prasad