Re: Store TIME in the Oracle

I will follow this way:

to_date('01-JAN-2000 '|| to_char(sysdate,'HH24:MI:SS'),'DD-MON-YYYY HH24:MI:SS')

I will put the date hard code for all lines inserted and the time that must be saved.

Regards
Eriovaldo

On Sun, Aug 14, 2011 at 9:19 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> For two main reasons.
>
> 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