Date function
Posted: 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
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