Re: Day of week
From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 19 Feb 2003 17:02:00 GMT
Message-ID: <MPG.18bd585f8ba791449896b1_at_news.la.sbcglobal.net>
Date: Wed, 19 Feb 2003 17:02:00 GMT
Message-ID: <MPG.18bd585f8ba791449896b1_at_news.la.sbcglobal.net>
johan.verlinden_at_iris.be said...
> How can I get the day of the week? Can I use TO_CHAR(my_date,'D')?
>
> Thanks?
>
How about:
select to_char(sysdate,'Dy') from dual; -- 'Day' for full day
-- /Karsten DBA > retired > DBAReceived on Wed Feb 19 2003 - 18:02:00 CET