Re: Date... Fixed Day, minus one month
From: Oliver <olitogo_at_gmail.com>
Date: Fri, 23 Jul 2010 05:59:00 -0700 (PDT)
Message-ID: <531f1d03-3cb5-436a-8f23-1b50b19b90dc_at_w31g2000yqb.googlegroups.com>
On 23 Jul., 13:37, Kay Kanekowski <kay.kanekow..._at_web.de> wrote: ...
> '20-' || TO_CHAR(ADD_MONTHS(sysdate - d.offset_day, -1), 'MM-
> YYYY HH:MM:SS') only_20th
...
Date: Fri, 23 Jul 2010 05:59:00 -0700 (PDT)
Message-ID: <531f1d03-3cb5-436a-8f23-1b50b19b90dc_at_w31g2000yqb.googlegroups.com>
On 23 Jul., 13:37, Kay Kanekowski <kay.kanekow..._at_web.de> wrote: ...
> '20-' || TO_CHAR(ADD_MONTHS(sysdate - d.offset_day, -1), 'MM-
> YYYY HH:MM:SS') only_20th
...
Does the Job. Thank you! VERY MUCH!
Oliver Received on Fri Jul 23 2010 - 07:59:00 CDT