DSXchange

I want to get DAYNAME from the Integer Date Type:

e.g.
Input: 20090520
Output: Wed

This is a px job, advance thanx for any help.

Try to use WeekdayFromDate function in the transformation stage.

Thanks sourabhverma,

From documentation "WeekdayFromDate" Returns the day number (int8) of the week from the given date.

Is this day number mean 1=Mon 2=Tue 3=Wed ........ ?

Am i right ?

Sunday is "day zero" of the week unless you override that with the OriginDate option, so yes as long as you know Sunday is 0 and not 7. Now, I think this can change under NLS... or can be changed by LOCALE... not sure.

Thanks Chullet.
WeekdayFromDate(link.datecolumn) gives Integer from 0-6. Used if conditions to get values for Sun-Sat.