Day Name of the Week From Date

ds2000 · Post by **ds2000** » Tue May 19, 2009 11:14 pm

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.

sourabhverma · Post by **sourabhverma** » Tue May 19, 2009 11:51 pm

Try to use WeekdayFromDate function in the transformation stage.

ds2000 · Post by **ds2000** » Wed May 20, 2009 7:21 am

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 ?

chulett · Post by **chulett** » Wed May 20, 2009 9:21 am

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.

ds2000 · Post by **ds2000** » Wed May 20, 2009 5:00 pm

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