Re: 1st Day of the Month

rios wrote:
> Is there a native function to tell is a date is FIRST day, Last DAY of the
> month ?
>
> other than this way:
> to_number(to_char(sysdate,'dd'))
>
> thanks
>
> --
> 10gR2

There is a function called last_day. Speaking of first day of month, untill now I was under the impression that all months start with 1. Am I missing something? :)

Gints Plivna
http://www.gplivna.eu Received on Mon Jan 08 2007 - 13:46:58 CST