Re: Day of week function?

From: Steve Davis <spd_at_patrol.i-way.co.uk>
Date: Wed, 03 Jun 1998 22:23:25 GMT
Message-ID: <3575ce0d.0@news.i-way.co.uk>

gjansen_at_cs.umd.edu (George Jansen) wrote:

>Having burned myself on this one before, I'd like to warn the reader to use
>RTRIM (unless, of course, you're only interested in Wednesday processing!):

> 1* select '*' || to_char(to_date('05-JUN-98'),'DAY') || '*' from dual
>SQL> /

>'*'||TO_CHAR(TO_DATE('05-JUN-98'),'DAY')||'*'
>-----------------------------------------------------------------------------
>*FRIDAY *
Use 'DAYFM' instead of 'DAY' to remove trailing spaces

Steve Received on Wed Jun 03 1998 - 17:23:25 CDT