Re: Store TIME in the Oracle
From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Sun, 14 Aug 2011 12:21:08 +0300
Message-ID: <4E479384.4020003_at_iki.fi>
Date: Sun, 14 Aug 2011 12:21:08 +0300
Message-ID: <4E479384.4020003_at_iki.fi>
Why not use interval day to second to store duration? You get Datetime
Arithmetic easier with that.
http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/sql_elements001.htm#autoId18
-- Timo Raitalaakso http://rafudb.blogspot.comReceived on Sun Aug 14 2011 - 04:21:08 CDT
> store duration as number of (milli)seconds.
>
> Niall
-- http://www.freelists.org/webpage/oracle-l