need help with a number conversion
From: Adam Hapworth <hap_at_mikomi.org>
Date: 11 Dec 2001 07:09:39 -0800
Message-ID: <a6cb04db.0112110709.47542b8c_at_posting.google.com>
Date: 11 Dec 2001 07:09:39 -0800
Message-ID: <a6cb04db.0112110709.47542b8c_at_posting.google.com>
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')
to_char(2,'day')
ORA-01846: not a valid day of week
ORA-01481: invalid number format model
any ideas will help Received on Tue Dec 11 2001 - 16:09:39 CET