Re: SQL*Plus display format question

From: <olen_kline_at_my-deja.com>
Date: Fri, 26 Jan 2001 21:04:00 GMT
Message-ID: <94sonp$e29$1@nnrp1.deja.com>

specify the date format in the format you want. If you want mmddyyyyhhmiss, put that is your format not mm/dd/yyyy....

In article <94sd30$2ns$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 15:04:00 CST