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
Date comparision (greater than or less than)
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Re: Date comparision (greater than or less than)
could be Use Oconv() and ICONV() fuctions after compare that
mgplk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Date comparision (greater than or less than)
In a parallel job?123gopal wrote:could be Use Oconv() and ICONV() fuctions after compare that
After?!!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Date comparision (greater than or less than)
use the functions ICONV() and OCONV() instead of using timestamp to date in parallel job
mgplk
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,
Pavan, can you provide the actual derivations you have written?
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.