Re: Good question on dates

select

    date_field + (number_field/24)
.....

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

argosy22_at_my-deja.com wrote in message <891lkn$gn6$1_at_nnrp1.deja.com>...
>Hello all,
>
>We have a new spec, and it's got a good skill
>testing question in it. We are using Oracle 7.3.4.
>
>We have a date field, and a number field.
>The number field indicates a number of hours.
>
>We need to combine these two to get a new date.
>(date + hours = new_date). (That date will then
>be compared to another date.)
>
>I've looked at the built in Oracle functions.
>There is the add_months() and next_day() functions.
>But that is not what I'm looking for.
>
>this gives:
>
>Select to_char(sysdate, 'DDD:HH24') Doy_hoD
>FROM DUAL
>
>DOY_HOD
>--------------
>054:16
>
>
>Is there a way to add these two fields together
>into a date in a simple manner? Or, do you think
>that I will have to write a complex function to do this?
>
>Thanks,
>
>Argosy
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Feb 23 2000 - 16:25:42 CST