Re: SQL*Plus display format question

In our last gripping episode wax_man_at_my-deja.com wrote:
> I'm having a problem with the SQL*Plus display of to_char queries and
> am looking for some help. If I run select to_char
 (sysdate,'mm/dd/yyyy
> hh:mi:ss') as "date" from dual, I get the following as the responce:
>
> date
> ----------------------------------------------------------------------
 --
> ---
> 01/26/2001 12:24:39
>
> Does anyone know how to get the date to print w/o all of the extra
> spaces/dashes? The date is displayed this way wether it is by itself,
> or in the middle of a big select clause.
>
> Thanks for any help,
>
> wax_man
>
> Sent via Deja.com
> http://www.deja.com/
>

column "date" format a20

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/