Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle question to get Date minus 1
pawan_test schrieb:
> hello Brian,
>
> thanks for your suggestions.
> this is what i tried.
>
> SQL> select to_date('20060928', 'YYYYMMDD') - 1 from dual;
>
>
> TO_DATE('
> ---------
> 27-SEP-06
>
>
> my desired output in this case is 20060927 but here the output is
> coming as 27-SEP-06.
SQL> select to_char(to_date('20060928', 'YYYYMMDD')-1,'YYYYMMDD') from dual;
Volker
-- For email replies, please substitute the obvious.Received on Fri Sep 29 2006 - 09:34:29 CDT
![]() |
![]() |