Storing Times in Oracle
From: Alan Clement <aclem_at_ibm.net>
Date: 1996/09/30
Message-ID: <52oujn$4va_at_dub-news-svc-7.compuserve.com>#1/1
Date: 1996/09/30
Message-ID: <52oujn$4va_at_dub-news-svc-7.compuserve.com>#1/1
I have a need to store times (eg elapsed times etc) in an Oracle7
database. As you may know there is no native TIME datatype in Oracle,
and the DATE datatype seems inadequate as it requires a date and time.
Does anyone have any suggestions, or has overcome this before ?
Cheers Alan
--
//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
Alan Clement
Application Designer
Baillie Gifford & Co.
Edinburgh EH3 8EY
Scotland, UK
Tel +44 131 222 4411
Fax +44 131 222 4486
Business: AClement_at_BaillieGifford.co.uk
Personal: aclem_at_ibm.net
CompuServe: 100432,3205
Web: http://www.tripod.com/~aclem/index.html
\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//
Received on Mon Sep 30 1996 - 00:00:00 CEST