Dan,
There is actually 48 seconds...
@Brad - I am not sure what you are trying to do, but you might consider
doing the diff on seconds and converting it to the number of days, minutes
seconds etc by calculating this. Plenty of examples how to turn seconds into
mins, hours, days etc.
On Thu, Ap
Can't you just use seconds, since the difference is under a minute?
#DateDiff("s", "2010-04-08 19:34:47.0", "2010-04-08 19:35:35.0")#
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 14 April 2010 00:08, Bradley Stone wrote:
>
> Thanks guys. I think the pr
Brad,
On Tuesday, April 13, 2010, Bradley Stone wrote:
>
> All:
>
> Feeding DateDiff() dates which are more than 24 hours apart yields minutes:
>
>
> #DateDiff("n", "2010-04-08 19:41:36.0", "2010-04-12 19:10:34.0")#
>
>
> Result: 5728
>
> However, feeding DateDiff() dates which are LESS than 2
> I was thinking that the function could function when the arguments are
> essentially the same day.
I'm a little confused. The dateDiff() function DOES work when the
arguments are the same day. Have we led you to believe otherwise, or
are you talking about a different "function" functioning?
Thanks guys. I think the problem is that that I was thinking that the function
could function when the arguments are essentially the same day. Here's what I
did to solve the problem: when the function returns 0, do this:
Using DatePart here seems to work fine!
~
Gotcha...I was thinking his examples were reversed...
-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com]
Sent: Tuesday, April 13, 2010 11:55 AM
To: cf-talk
Subject: Re: DateDiff() and Minutes Wierdness
That was his first example, which worked for him. His second
age-
> From: Raymond Camden [mailto:rcam...@gmail.com]
> Sent: Tuesday, April 13, 2010 9:09 AM
> To: cf-talk
> Subject: Re: DateDiff() and Minutes Wierdness
>
>
> Um, aren't those times like 50 seconds or so apart? Isn't 50 seconds <
> 1 minute? Th
Yes, the long datetime in SQL Server tracks out to fractions of seconds.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion
second? Never worked with time and decimal places.
-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com]
Sent: Tuesday, April 13, 2010 9:09 AM
To: cf-talk
Subject: Re: DateDiff() and Minutes Wierdness
Um, aren't those times like 50 seconds or so apart? Isn
teah change your evaluator to seconds and do the multiplication.
On Tue, Apr 13, 2010 at 9:09 AM, Raymond Camden wrote:
>
> Um, aren't those times like 50 seconds or so apart? Isn't 50 seconds <
> 1 minute? Therefore 0 "full" minutes?
>
> On Tue, Apr 13, 2010 at 7:32 AM, Bradley Stone wrote:
>>
Um, aren't those times like 50 seconds or so apart? Isn't 50 seconds <
1 minute? Therefore 0 "full" minutes?
On Tue, Apr 13, 2010 at 7:32 AM, Bradley Stone wrote:
>
> All:
>
> Feeding DateDiff() dates which are more than 24 hours apart yields minutes:
>
>
> #DateDiff("n", "2010-04-08 19:41:36.0
All:
Feeding DateDiff() dates which are more than 24 hours apart yields minutes:
#DateDiff("n", "2010-04-08 19:41:36.0", "2010-04-12 19:10:34.0")#
Result: 5728
However, feeding DateDiff() dates which are LESS than 24 hours apart yields
nothing:
#DateDiff("n", "2010-04-08 19:34:47.0", "201
12 matches
Mail list logo