Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date and time
Choung wrote:
> Hi,
>
> I have a field that stores the date and time but every time I query the
> table it only spits out the date. What should it say to spit out both the
> date and time?
>
> thanks
>
>
format the column, eg.
select to_char(sysdate,'DD/MON/YYYY HH24:MI:SS') from dual; Received on Mon Jan 05 2004 - 14:02:03 CST