3 weeks ago - last edited 3 weeks ago
Hi All
Need to see records for last 4 Months(120 Days) , this condition I need to apply in query transformation where clause in Designer based on a Date field-ERDAT which contains values in format: yyyy.mm.dd
I tried to use below condition but bods not permitting this condition:
ERDAT >= dateadd( day, -120, CURRENT_DATE());
Please anyone assist me on this .
Regards,
Siba
This is a snippet from one of my dataflows in the WHERE clause.
to_char(RECORDDATE, 'yyyy.mm.dd') > to_char(sysdate()-45, 'yyyy.mm.dd')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.