Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle question to get Date minus 1
On 28 Sep 2006 20:16:05 -0700, "pawan_test" <sridhara007_at_gmail.com>
wrote:
>my desired output in this case is 20060927 but here the output is
>coming as 27-SEP-06.
>
>can anyone please suggest me how do I get the output as 20060927
Do you know the to_char function?
If not, please look it up in the SQL reference manual.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Sep 29 2006 - 00:20:48 CDT