Date... Fixed Day, minus one month
From: Oliver <olitogo_at_gmail.com>
Date: Fri, 23 Jul 2010 03:49:29 -0700 (PDT)
Message-ID: <783443f6-2cbc-435d-bc4a-5bfc2ef9de0c_at_f6g2000yqa.googlegroups.com>
Dear all
Date: Fri, 23 Jul 2010 03:49:29 -0700 (PDT)
Message-ID: <783443f6-2cbc-435d-bc4a-5bfc2ef9de0c_at_f6g2000yqa.googlegroups.com>
Dear all
It might be a trivial issue for you.. but it keeps me busy and I'd be glad for help.
Lets say, we now have "23.07.2010 13:45:21" as dd.mm.yyyy hh:mm:ss. I like to get the following date 20.06.2010. This is "today minus one month" and "always day 20".
What I have currently is:
TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'DD-MM-YYYY HH:MM:SS')
I've been traing with a lot of things but couldn't get it working...
How can I have a fixed day in DD?
Oliver Received on Fri Jul 23 2010 - 05:49:29 CDT