Re: date and time

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 05 Jan 2004 12:47:18 -0800
Message-ID: <1073335552.19528@yasure>

Bricklen wrote:

> 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;

Also look at the various ALTER SESSION options at http://tahiti.oracle.com.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Jan 05 2004 - 14:47:18 CST