Re: Day of week

From: XelA <asilic_at_net.hr>
Date: Wed, 19 Feb 2003 16:13:58 +0100
Message-ID: <b306vp$3or$1_at_sunce.iskon.hr>


[Quoted] "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;

So if that is what you want... :))))

Regards!
XelA Received on Wed Feb 19 2003 - 16:13:58 CET

Original text of this message