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.