Re: hidden value in date field?

From: Tim X <timx_at_spamto.devnul.com>
Date: 26 Jan 2003 17:46:33 +1100
Message-ID: <877kcs8l2u.fsf@tiger.rapttech.com.au>

>>>>> "Peter" == Peter Valicek <sonny_at_valicek.net> writes:

 Peter> Hallo NG, just a little quetsion about datatype date.

 Peter> We had an 8.1.7 Database. In alle fields where in my opinion
 Peter> should be as well an time value only the date is in like
 Peter> 23-jan-03. I have checked nearby all tables but nowhere is the
 Peter> time givven. But in our applikation is time very essential so
 Peter> it have to be there. In my eyes it does it not make much sence
 Peter> to split date and time in seperate fileds.

 Peter> Exist an command or an special select ( like extend in

 Peter> informix ) do extend the field, if it's as well in the field  Peter> but not obvisuely seen?

 Peter> Or let me say it other.  Is the time value as well in the date
 Peter> field but hidden? If yes hot to get it? if no has anyone an
 Peter> idea?

Oracle stores the complete date and time in a date field. What is displayed is determined by the format string. There is a default format string which is used if no format is provided in date operations e.g.

select SYSDATE
from dual

will give whatever the default format string specifies - this is often 'DD-MON-YY'. e.g. 26-JAN-03

If you specify a date format which includes time elements, you will see the time details e.g.

select to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') from dual

will give a date like '26-JAN-2003 17:56:21'

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Received on Sun Jan 26 2003 - 00:46:33 CST