SQL*Plus display format question

From: <wax_man_at_my-deja.com>
Date: Fri, 26 Jan 2001 17:37:00 GMT
Message-ID: <94scjr$26s$1@nnrp1.deja.com>

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/ Received on Fri Jan 26 2001 - 11:37:00 CST