Re: Date calculation function

Am Wed, 12 Jan 2005 17:10:42 GMT schrieb Randy Harris <randy_at_SpamFree.com>:

>> function Add_Weeks(Start_Date in date,
>> Weeks_To_Add in number) return date
>> is
>> begin
>> return Start_Date + Weeks_To_Add * 7;
>> end Add_Weeks;
>> /
>>
>> Regards,
>> --
>> Frank Piron,
>> defrankatkonaddot
>> (leftrotate two)
>
> Frank, am I interpreting this correctly? If I add an integer to a date,
> it
> assumes I am adding days and returns the date offset by that many days?

Yes, a (real) number in operations (+ or -) containing dates is interpreted as a *duration* . The unit of measure of duration is a day. So for example the difference of two dates date_1 - date_2 is the number of day between date_1 and date_2.

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)