date functions

[SwathiCh]

Hi ,

I have a requirement to implement oracle logic in datastage.

Oracle funcion:-
(trunc(sysdate,'D') This yields last day of previous week.i.e. sunday

suppose if system date is 1/11/2011(tuesday) ,output of (trunc(sysdate,'D') is 1/09/2010(sunday).

Can someone help me how to implement this in datasatge.

Thanks,

[chulett]

Oracle funcion:-
(trunc(sysdate,'D') This yields last day of previous week.i.e. sunday

Sorry, but no it does not. It simply returns the current day.

[chowdhury99]

Following will give next Sunday. If you deduct 7 days, you will get previous Sunday.

Next_Day(to_date(date,'dd-mon-yy'), 'Sunday')


Thanks.

[parimi123]

Code: Select all

DateFromDaysSince(-WeekdayFromDate(CurrentDate()),CurrentDate()) 

returns last Sunday in 'YYYY-MM-DD'.

[SwathiCh]

Thanks for all your inputs.
DateFromDaysSince(-WeekdayFromDate(CurrentDate()),CurrentDate()) .This fullfilled my requirement.

adding more....
to_date(trunc(sysdate,'D')+7).just want to know whether this be achieved in datastage?

[priyadarshikunal]

Code: Select all

DateFromDaysSince(-WeekdayFromDate(CurrentDate())+7,CurrentDate())