Re: Store TIME in the Oracle

1. - the good reason - we don't know the dbversion or the tools in use here. They *will* understand numbers, they may not understand intervals.
2. - the bad reason - I haven't tested & investigated how well interval works in practice (stats estimation etc).

On Sun, Aug 14, 2011 at 10:21 AM, Timo Raitalaakso <rafu_at_iki.fi> wrote:

>
> 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<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
>>
>
> --
> http://www.freelists.org/**webpage/oracle-l<http://www.freelists.org/webpage/oracle-l>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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