Re: timestamp and date format

Bruintje Beer wrote:
> Hi,
>
> I am new to oracle. How can I change the timestamp and date format to
> dd-mm-yyyy hh:mm:ss for timestamp and dd-mm-yyyy for date.
>
> Thanks
>
> John

Dates are not stored as a string internally. You can change the display format though by using the to_char function. select to_char(sysdate, 'dd-mm-yyyyy') from dual;

Doc questions are best avoided here.
The SQL reference manual at http://tahiti.oracle.com is your friend.

-- 
Sybrand Bakker
Senior Oracle DBA