Re: Oracle date functions

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 1 Dec 2001 12:22:12 +0100
Message-ID: <u0humrbcaofr12@corp.supernews.com>

"angshu" <angshu_at_agnisoft.com> wrote in message news:9u5ou1$igd$1_at_news.vsnl.net.in...
> Hi, ... this might be very trival to all but I don't know
> how to get the month, day or year from a date!
> Is there anything like Month( ) , Day ( ) ?
> Or do I have to do to_char(pDate,'MM') and then convert to
> integer?
>
> TIA
> ~angshu
>
>
>
>
>
>

Yes, you need to use to_char.
There is no need to convert to integer if the variable you are assigning to is an integer.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sat Dec 01 2001 - 05:22:12 CST