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'.
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).