Re: Oracle date functions

angshu wrote:
>
> 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?

Yes. Generally you apply the to_char() functions to the date expression. Conversions to numeric types are done automatically.

U.

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!