Re: Date... Fixed Day, minus one month
From: Oliver <olitogo_at_gmail.com>
Date: Fri, 6 Aug 2010 01:31:39 -0700 (PDT)
Message-ID: <3aee98f4-8b62-476f-b55b-ba9f9f0a7a5e_at_m1g2000yqo.googlegroups.com>
On 23 Jul., 18:10, Shakespeare <what..._at_xs4all.nl> wrote: ...
>
> How about:
>
> SQL> select trunc(sysdate - interval '1' month,'MM') + interval '19' day
> from dual;
> I like the interval syntax because it documents exactly what and how
> many you are adding to a date.
>
> Shakespeare
Date: Fri, 6 Aug 2010 01:31:39 -0700 (PDT)
Message-ID: <3aee98f4-8b62-476f-b55b-ba9f9f0a7a5e_at_m1g2000yqo.googlegroups.com>
On 23 Jul., 18:10, Shakespeare <what..._at_xs4all.nl> wrote: ...
>
> How about:
>
> SQL> select trunc(sysdate - interval '1' month,'MM') + interval '19' day
> from dual;
> I like the interval syntax because it documents exactly what and how
> many you are adding to a date.
>
> Shakespeare
Agree and changed my code.
Thank you!
Oliver Received on Fri Aug 06 2010 - 03:31:39 CDT