Re: oracle dates calculations

From: DangerMouse <nospam_at_nospam.com>
Date: Fri, 27 Jun 2003 19:07:59 +0100
Message-ID: <4K%Ka.208$Ls.2422@newsfep4-glfd.server.ntli.net>

"Eric Parker" <eric.parker.spamless_at_virgin.net> wrote in message news:Pk%Ka.2249$MO2.1910_at_newsfep4-winn.server.ntli.net...
>
> What I was wondering about was the standard (if there is one) way of
dealing
> with somebody whose birthday was 29th Feb. Does their birthday become
> 28th Feb or 1st Mar on non-leap years ?
> I know from an Oracle point of view what I'd prefer.
>
> eric
>
>
>

Appears to be the 28th from the server's point of view, as documented in the manual when converting between months with unequal numbers of days; don't know if that reflects real life as I don't know anyone born on the 29th Feb:

SQL> select add_months(to_date('29-FEB-2000'),12) from dual;

ADD_MONTHS(

---

28-FEB-2001 Regards
DM Received on Fri Jun 27 2003 - 13:07:59 CDT