Re: Day of week
Date: Wed, 19 Feb 2003 17:26:45 -0000
Message-ID: <b30f5i$ifh$1_at_pheidippides.axion.bt.co.uk>
"XelA" <asilic_at_net.hr> wrote in message news:b306vp$3or$1_at_sunce.iskon.hr...
> "Johan Verlinden" <johan.verlinden_at_iris.be> wrote in message
> news:3e539e4f$0$14666$ba620e4c_at_news.skynet.be...
> > How can I get the day of the week? Can I use TO_CHAR(my_date,'D')?
> >
> > Thanks?
> >
>
> If you want day of the week in number... Yes, you can...
>
> You can try to execute it like this...
>
> select TO_CHAR(sysdate, 'D')
> from dual;
John,
it's worth remembering that session based NLS settings can cause different values to be returned. I ran this query today (a Wednesday) and it returned a value of '3' . I altered my session NLS_TERRITORY to AMERICA (from UNITED KINGDOM), re-ran the query and got '4'.
Paul Dixon Received on Wed Feb 19 2003 - 18:26:45 CET