Re: Store TIME in the Oracle

  • From: Timo Raitalaakso <rafu@xxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 14 Aug 2011 12:21:08 +0300
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.com


store duration as number of (milli)seconds.

Niall


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2011