Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle question to get Date minus 1

Re: oracle question to get Date minus 1

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Sep 2006 19:22:32 +0200
Message-ID: <khlqh21ph2q2psqcdpk5vbr7b1m1jv9bjn@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


Received on Fri Sep 29 2006 - 12:22:32 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US