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

All Oracle date functions can be found at: http://www.psoug.org/reference/builtin_functions.html

For example scroll down to: LAST_DAY
and click on the icon.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org