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

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

oracle question to get Date minus 1

From: pawan_test <sridhara007_at_gmail.com>
Date: 28 Sep 2006 16:43:40 -0700
Message-ID: <1159487020.268375.15430@e3g2000cwe.googlegroups.com> 





can anyone also please suggest me for the following



this is oracle question



say TIME=20060928


desired output: 20060927



say TIME=20061001


DESIRED output: 20060930



If i substract one day from 'TIME' i am looking for previous day.



can anyone please suggest me how do i do this is SQL.



thanks


mark
Received on Thu Sep 28 2006 - 18:43:40 CDT












Original text of this message













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