Re: oracle question to get Date minus 1

From: tony_becky_mikey_verizon_news <tony_becky_mikey_at_verizon.net>
Date: Sat, 30 Sep 2006 23:36:44 GMT
Message-ID: <gcDTg.198$pS3.18@trnddc01>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:khlqh21ph2q2psqcdpk5vbr7b1m1jv9bjn_at_4ax.com...
> On Fri, 29 Sep 2006 16:34:29 +0200, Volker Hetzer
> <firstname.lastname_at_ieee.org> wrote:
>
>>SQL> select to_char(to_date('20060928', 'YYYYMMDD')-1,'YYYYMMDD') from
>>dual;
>>
>>Volker
>
>
> PLEASE do NOT SPOON FEED the OP, who should be teached to read
> manuals.
>
> --
> Sybrand Bakker, Senior Oracle DBA

You mean Taught to read the manuals, right??

Just a lurker in Seattle.. Received on Sat Sep 30 2006 - 18:36:44 CDT