Date comparision (greater than or less than)

[pavan_test]

Hi All,

I have source datatype from oracle as 'date'. I am reading this as timestamp.

I have another source from different table with datatype as 'date' and i am reading this as timestamp.

in ETL transformer, I am using timestamptodate function to convert them to date.

I am trying to achieve this in ETL, if a > b and a<=c then output 'true'

after i use TimestampToDate function i find these values in peek stage for a,b,c

a= 2006-03-24
b=2004-06-07
c=2007-05-24

when i try this in transformer a > b and a<=c, i get null in the output. can someone please suggest. Thanks You.
can

[srinivas.nettalam]

Where are you writing this derivation? What is the datatype of the field/variable where you are writing this expression?

[bob7027]

change the data type for all fields to timestamp & check with 'isvalid' condition for 'timestamp', then you can write if then else condition

thx

[123gopal]

could be Use Oconv() and ICONV() fuctions after compare that

[ray.wurlod]

could be Use Oconv() and ICONV() fuctions after compare that

In a parallel job?
After?!!

[123gopal]

use the functions ICONV() and OCONV() instead of using timestamp to date in parallel job

[jwiles]

123gopal: To echo Ray's question, why? ICONV and OCONV would require the use of a BASIC transformer, potentially affecting performance if this parallel job.

Pavan, can you provide the actual derivations you have written?

Regards,