Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 1st Day of the Month

Re: 1st Day of the Month

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Jan 2007 14:41:46 -0800
Message-ID: <1168296106.253981.57810@q40g2000cwq.googlegroups.com>

Michel Cadot wrote:
> "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

The first day of the month can be found via select trunc(sysdate,'MM') from sys.dual

HTH -- Mark D Powell -- Received on Mon Jan 08 2007 - 16:41:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US