Re: oracle question to get Date minus 1

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Fri, 29 Sep 2006 02:38:49 GMT
Message-Id: <pan.2006.09.29.02.38.35.107325@verizon.net>

On Thu, 28 Sep 2006 16:50:40 -0700, pawan_test wrote:

> 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

It's very simple:

SQL> select to_char(sysdate+cos(3.14159265359),'MM/DD/YYYY HH24:MM::SS') from dual; 2

TO_CHAR(SYSDATE+FLOO

---

09/27/2006 22:09::28

-- 
http://www.mladen-gogala.com

Received on Thu Sep 28 2006 - 21:38:49 CDT