Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus display format question
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
> >
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 26 2001 - 15:04:00 CST