RE: time difference
Welcome back Christopher...from a fellow Army vet. Glad to see you back!
Yeah...things have changed quite a bit in the past 7 years...CF has
definitely improved and grown over the years.
Eric
-Original Message-
From: Christopher Stowell [mailto:christopher.stow...@yahoo.com]
Sent: Saturday, March 06, 2010 8:23 AM
To: cf-talk
Subject: Re: time difference
Ya know.. after being out of ColdFusion development since 2003 (joined the
army and just got out late 2009), i must say.. its odd seeing some of the
same names on the list. Not to mention the fact people still have a sense
of humor here :) Now, its time to start getting back into this and figure
out all teh changes made in the last 7 years LOL (man this is gonna hurt)
From: Rick Faircloth
To: cf-talk
Sent: Sat, March 6, 2010 7:04:50 AM
Subject: RE: time difference
Uh, oh... you guys just couldn't let a sleeping dog lie, huh? ;o)
Rick
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Friday, March 05, 2010 10:39 PM
To: cf-talk
Subject: RE: time difference
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff("", '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time difference
> 2 ?'s
> I need to show a difference between to dates
> basically how much time is left between the ending date and now. can
> cf do this or should I use a java script?
>
> also, how do I use a Now() but add 3 hours to the output?
> server is 3 hours behind but I need to be the current time. I don't
> think the java get current time will work because I need to retrieve
> it from a db
>
> lots o ?'s tonight
> why see below! haha
>
> dave
>
>
My god. This still holds true today! Wanna chime in Rick??? LOL!!
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331412
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: time difference
Hi, Christopher...and thanks for your service!
I was in from 1984-'88...Fort Bragg.
Welcome back! What was the last version of CF you used?
And concerning "seeing some of the same names on the list"...we can't
seem to get rid of some people, like Dave, the
Disrupter
he's quite (this part was not intelligible)!!!
Rick
-Original Message-
From: Christopher Stowell [mailto:christopher.stow...@yahoo.com]
Sent: Saturday, March 06, 2010 9:23 AM
To: cf-talk
Subject: Re: time difference
Ya know.. after being out of ColdFusion development since 2003 (joined the
army and just got out late 2009), i must say.. its odd seeing some of the
same names on the list. Not to mention the fact people still have a sense
of humor here :) Now, its time to start getting back into this and figure
out all teh changes made in the last 7 years LOL (man this is gonna hurt)
From: Rick Faircloth
To: cf-talk
Sent: Sat, March 6, 2010 7:04:50 AM
Subject: RE: time difference
Uh, oh... you guys just couldn't let a sleeping dog lie, huh? ;o)
Rick
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Friday, March 05, 2010 10:39 PM
To: cf-talk
Subject: RE: time difference
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff("", '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time difference
> 2 ?'s
> I need to show a difference between to dates
> basically how much time is left between the ending date and now. can
> cf do this or should I use a java script?
>
> also, how do I use a Now() but add 3 hours to the output?
> server is 3 hours behind but I need to be the current time. I don't
> think the java get current time will work because I need to retrieve
> it from a db
>
> lots o ?'s tonight
> why see below! haha
>
> dave
>
>
My god. This still holds true today! Wanna chime in Rick??? LOL!!
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331411
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
Ya know.. after being out of ColdFusion development since 2003 (joined the army
and just got out late 2009), i must say.. its odd seeing some of the same names
on the list. Not to mention the fact people still have a sense of humor here
:) Now, its time to start getting back into this and figure out all teh
changes made in the last 7 years LOL (man this is gonna hurt)
From: Rick Faircloth
To: cf-talk
Sent: Sat, March 6, 2010 7:04:50 AM
Subject: RE: time difference
Uh, oh... you guys just couldn't let a sleeping dog lie, huh? ;o)
Rick
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Friday, March 05, 2010 10:39 PM
To: cf-talk
Subject: RE: time difference
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff("", '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time difference
> 2 ?'s
> I need to show a difference between to dates
> basically how much time is left between the ending date and now. can
> cf do this or should I use a java script?
>
> also, how do I use a Now() but add 3 hours to the output?
> server is 3 hours behind but I need to be the current time. I don't
> think the java get current time will work because I need to retrieve
> it from a db
>
> lots o ?'s tonight
> why see below! haha
>
> dave
>
>
My god. This still holds true today! Wanna chime in Rick??? LOL!!
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: time difference
Uh, oh... you guys just couldn't let a sleeping dog lie, huh? ;o)
Rick
-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Friday, March 05, 2010 10:39 PM
To: cf-talk
Subject: RE: time difference
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff("", '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time difference
> 2 ?'s
> I need to show a difference between to dates
> basically how much time is left between the ending date and now. can
> cf do this or should I use a java script?
>
> also, how do I use a Now() but add 3 hours to the output?
> server is 3 hours behind but I need to be the current time. I don't
> think the java get current time will work because I need to retrieve
> it from a db
>
> lots o ?'s tonight
> why see below! haha
>
> dave
>
>
My god. This still holds true today! Wanna chime in Rick??? LOL!!
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331408
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
The sad part here is that now 7 years later Will still would have to look this up! And thank god we got bobbie here to referee the "proper" count! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: time difference
Is there really a need to bring one of his threads back to life? Especially
one that has been dead for #dateDiff("", '02-10-2003', now())# years...
-Original Message-
From: Will Tomlinson [mailto:w...@wtomlinson.com]
Sent: Friday, March 05, 2010 7:39 PM
To: cf-talk
Subject: Re: time difference
> 2 ?'s
> I need to show a difference between to dates
> basically how much time is left between the ending date and now. can
> cf do this or should I use a java script?
>
> also, how do I use a Now() but add 3 hours to the output?
> server is 3 hours behind but I need to be the current time. I don't
> think the java get current time will work because I need to retrieve
> it from a db
>
> lots o ?'s tonight
> why see below! haha
>
> dave
>
>
My god. This still holds true today! Wanna chime in Rick??? LOL!!
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331401
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
>actually >I already have it:) >just really sick of reading it at the moment. lots to absorb, short amount >of time > >> Dave, >> CF is a lot to absorb chief!! LOL!!! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
> 2 ?'s > I need to show a difference between to dates > basically how much time is left between the ending date and now. can > cf do this or should I use a java script? > > also, how do I use a Now() but add 3 hours to the output? > server is 3 hours behind but I need to be the current time. I don't > think the java get current time will work because I need to retrieve > it from a db > > lots o ?'s tonight > why see below! haha > > dave > > My god. This still holds true today! Wanna chime in Rick??? LOL!! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
Dave Lyons wrote: > > also, how do I use a Now() but add 3 hours to the output? > server is 3 hours behind but I need to be the current time. I don't think the java >get current time will work because I need to retrieve it from a db From the database you might want to use: SELECT field AT TIME ZONE 'GMT' FROM table Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: time difference
thanks! sorry for the simple and dumb ?'s just tired and trying to learn this stuff, run my companies and do ASP has me spinning right now. - Original Message - From: "Justin Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 9:55 PM Subject: Re: time difference > > I need to show a difference between to dates > > datediff(part, date1, date2) > > > also, how do I use a Now() but add 3 hours to the output? > > dateadd(part, num, date) > > -Justin > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: time difference
actually I already have it:) just really sick of reading it at the moment. lots to absorb, short amount of time - Original Message - From: "Jared Clinton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 9:48 PM Subject: RE: time difference > Dave, > > You need this book - get your company to buy it : > http://www.amazon.com/exec/obidos/tg/detail/-/0321125169/qid=1044931725/sr=1 > -7/ref=sr_1_7/002-1188732-7097602?v=glance&s=books > or > http://makeashorterlink.com/?W21741B63 > > It is the "ColdFusion MX Web Application Construction Kit, Fifth Edition" > #ISBN: 0321125169 > > There are versions available for CF4 and CF5 if that is what you require. > > Regards, > Jared Clinton. > > -Original Message- > From: Dave Lyons [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 11 February 2003 1:45 PM > To: CF-Talk > Subject: time difference > > > 2 ?'s > I need to show a difference between to dates > basically how much time is left between the ending date and now. can cf do > this or should I use a java script? > > also, how do I use a Now() but add 3 hours to the output? > server is 3 hours behind but I need to be the current time. I don't think > the java get current time will work because I need to retrieve it from a db > > lots o ?'s tonight > why see below! haha > > dave > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: time difference
> I need to show a difference between to dates datediff(part, date1, date2) > also, how do I use a Now() but add 3 hours to the output? dateadd(part, num, date) -Justin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: time difference
Dave, You need this book - get your company to buy it : http://www.amazon.com/exec/obidos/tg/detail/-/0321125169/qid=1044931725/sr=1 -7/ref=sr_1_7/002-1188732-7097602?v=glance&s=books or http://makeashorterlink.com/?W21741B63 It is the "ColdFusion MX Web Application Construction Kit, Fifth Edition" #ISBN: 0321125169 There are versions available for CF4 and CF5 if that is what you require. Regards, Jared Clinton. -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 February 2003 1:45 PM To: CF-Talk Subject: time difference 2 ?'s I need to show a difference between to dates basically how much time is left between the ending date and now. can cf do this or should I use a java script? also, how do I use a Now() but add 3 hours to the output? server is 3 hours behind but I need to be the current time. I don't think the java get current time will work because I need to retrieve it from a db lots o ?'s tonight why see below! haha dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Difference Function - newbie!!!!!
Doesn't datediff return a number not a date ?
ie, number if seconds or number if months dependiing on what u specifiy, you
can use dateadd to add the datediff calculated figure back on though I think
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2001 22:26
To: CF-Talk
Subject: Time Difference Function - newbie!
Hello again!
I am having some trouble calculating the time
difference for two datetime field2 which I then try
and add togetherhere is what I have done:
My SQL Stmt:
Select DateDiff("mi", dApptEndTime,
dApptBeginTime) as Diff1,
DateDiff("mi", dApptEndTime2, dApptBeginTime2) as
Diff2,
cas.icasacapptID,
cas.dApptBeginTime as BeginTime,
cas.dApptEndTime as EndTime,
cas.dApptBeginTime2 as BeginTime2,
cas.dApptEndTime2 as EndTime2,
'None' as TimeCode,
cli.iclientID,etc
then later in the code I do a cfset:
I get an error stating that it cannot convert to
number..
How can I get around this?
Thanks a million!!!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
