Date function

neeraj · Post by **neeraj** » Mon Jun 07, 2010 4:38 pm

HI,

I need the help in getting the correct date.

I have a weekly job and whatever date of the current week, i run my job, it extracts the data from previous sunday to Saturday.

I want to put a constraint in datatstage to extract the data only from Saturday only.

In Oracle, I have used the below mentioned function to get
get the data from saturday
next_day(to_date('2010-06-07','YYYY-MM-DD') -7,'Sunday')-8

I am looking for similar constraint in Datastage.

Regards
Neeraj

ray.wurlod · Post by **ray.wurlod** » Mon Jun 07, 2010 6:09 pm

There are a few, such as DateFromDaysSince(), PrevWeekdayFromDateSince() and so on. Do some research to find out precisely the one that best fits your particular requirement. They're in an appendix of the Parallel Job Developer's Guide.