Re: 1st Day of the Month

"Gints Plivna" <gints.plivna_at_gmail.com> a écrit dans le message de news: 1168285618.482307.18120_at_v33g2000cwv.googlegroups.com...
| 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
|

Wrong! It is the day after the last day of the previous month. :)

Regards
Michel Cadot Received on Mon Jan 08 2007 - 14:19:19 CST