Re: maybe a dumb sql question

Tony! wrote:
> Why does select trunc(sysdate) from dual;
> return 
> 11/13/2003 
> and 
> select rtrim(trunc(sysdate)) from dual;
> return
> 13-NOV-03
> ?
>
> Why would the function to trim extra spaces from the right side cause
> the date siaplay format to change?
>
> -----
> I'll take "Things that make this newbie go hmmmmm  Alex."
>
> Tony!
It doesn't:
SQL> select trunc(sysdate) from dual;

TRUNC(SYSDATE)
---------------
14-NOV-03

SQL> select rtrim(trunc(sysdate)) from dual;

RTRIM(TRUNC(SYSDATE))
---------------------------
14-NOV-03

--
Regards, Frank van Bortel