Filter Stage using sysdate in WHERE clause

urahul · Post by **urahul** » Mon Jul 04, 2005 8:44 am

Hi,
I am using filter stage to filter out records based on a date filed.
In order to select the latest day's records i would like to use sysdate.
Can anybody please help me with the same, because it seems sysdate doesnt work with DataStage.
The condition in where goes like this:
DATE_FILED > SYSDATE

Thanks
Rahul

elavenil · Post by **elavenil** » Mon Jul 04, 2005 8:58 am

The current date can be obtained using Date functions available in PX. You may need to reformat the result.

HTWH.

Regards
Saravanan

urahul · Post by **urahul** » Mon Jul 04, 2005 9:03 am

Hi,
Can we use DataStage DATE function in Filter Stage?
if yes could you please let me know how.

Thanks
Rahul

elavenil · Post by **elavenil** » Tue Jul 05, 2005 2:42 am

DATE function cannot be used in the filter stage as filter stage is a PX stage.

Look at the document which date functions can be used in PX stages.

Regards
Saravanan

bcarlson · Post by **bcarlson** » Wed Jul 06, 2005 12:37 pm

You could use the Column Generator Stage to add a date column that contains the current date (the 'Use Current Date' option in the Column Meta Data editor).

Then your Filter Stage uses a where clause the compares your input date to the new current date field.