--
From: Alex Ninan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 10:16 AM
To: CF-Talk
Subject: RE: days between function in Oracle...
lets say I have certain dates (x) and (y)
now I do a ((x) - (y)) in oracle and I get a number like 18.12 or 18.82
I was doing a round of the result abov
helps clarify the question... More of a rounding issue.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 10:10 AM
To: CF-Talk
Subject: Re: days between function in Oracle...
ceiling() will round up
What's your question ...days beween dat
ceiling() will round up
What's your question ...days beween dates or rounding?
On Tue, 20 Aug 2002, Alex Ninan wrote:
> Hi,
>
> Does anyone know of a function I can use to get the number of days between 2
> dates in Oracle. My basic problem is I can get the dates but on using the
> round functi
Thanks Sam, That's exactly what I wanted.
Learnt something new today... Ceil and Floor functions...
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 9:52 AM
To: CF-Talk
Subject: Re: days between function in Oracle...
Use the Ceiling or
Use the Ceiling or Ceil function (can't remember exactly which one it is)
Cheers,
Sam
- Original Message -
From: "Alex Ninan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 11:32 AM
Subject: days between function in Oracle...
> Hi,
>
> Does anyon
Use the Oracle trunc function on the dates. Trunc() removes the time
portion so both dates are at midnight.
trunc(date1) - trunc(date2)
Dan
> -Original Message-
> From: Alex Ninan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 11:32 AM
> To: CF-Talk
> Subject: days between
Using ROUND() on the dates seems to work. Try something like this:
ROUND(date2) - ROUND(date1)
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
> -Original Message-
> From: Alex Ninan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday,
7 matches
Mail list logo