Re: Is there a dateadd() function?

>The results you have descibe appear to be just whole days (?)

No. (Date2- Date1) * 24 gives you a number with a lot a decimals, like 1.8372342. The whole part is the number of days, and that is why I used trunc(..) in my second example.

Just try, you'll see.

Arjan. Received on Wed Jul 22 1998 - 00:00:04 CDT