need help with a number conversion

I am having a hard time trying to make this work.

I have a number 1-7 for each day of the week in a database. I want to turn that into the 'day' format so 1 = 'sunday' and so on. I have tried a number of different ways but none of them work. I need this to do the next_day() function in oracle 8

to_date(2,'day')
ORA-01846: not a valid day of week

to_char(2,'day')
ORA-01481: invalid number format model

any ideas will help Received on Tue Dec 11 2001 - 16:09:39 CET