Re: user defined data type

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 20 Jun 2001 13:31:22 -0700
Message-ID: <F001.00330CCC.20010620132028@fatcity.com>

A date field contains both the date and time. If you only want to display the time use a call to to_char(my_date,'HH:MM:SS'). If for some reason you REALLY only want to store the time of day, I would store the number of seconds since midnight in a number. for example 6:32.35pm would be (18*60*60) + (32*60)+35 or 66755. This would allow the user to sort by the time. A third way would be to use a varchar2 field and store the time as HHMMSS or using my example above '183235'.

>>> Harvinder.Singh_at_MetraTech.com 06/20/01 02:54PM >>>
Hi,

Developers need a datatype which only stores the time portion of date i.e. HH24:MI:SS.......
Any ideas how to create this data type.

Thanks
Harvinder

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Harvinder Singh
  INET: Harvinder.Singh_at_MetraTech.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 20 2001 - 15:31:22 CDT