johann.... 6.1 ent
tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Johan Steenkamp [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:38 PM To: CF-Talk Subject: Re: DateDiff() broken in 6.1 (Bug?) Hi Tony Thanks for testing - can you confirm your test was on CF 6.1? If so was it Standard or Enterprise version? My testing is on Standard. It works on 6.0 for me but not 6.1 Noted I can get the correct result by adding 1 hour to the second date. Displaying system getTimeZoneInfo() shows not difference between 6.0 or 6.1 systems so does not look like anything with localization/time. regards Johan ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 3:36 PM Subject: RE: DateDiff() broken in 6.1 (Bug?) > here is what i get... > > 1. {ts '2003-05-01 00:00:00'} - {ts '2003-10-01 00:00:00'} = 153 2. > {ts '2003-05-01 00:00:00'} - {ts '2003-10-02 00:00:00'} = 154 3. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-03 00:00:00'} = 155 4. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-04 00:00:00'} = 156 5. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-05 00:00:00'} = 157 6. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-06 00:00:00'} = 158 7. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-07 00:00:00'} = 159 8. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-08 00:00:00'} = 160 9. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-09 00:00:00'} = 161 10. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-10 00:00:00'} = 162 11. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-11 00:00:00'} = 163 12. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-12 00:00:00'} = 164 13. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-13 00:00:00'} = 165 14. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-14 00:00:00'} = 166 15. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-15 00:00:00'} = 167 16. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-16 00:00:00'} = 168 17. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-17 00:00:00'} = 169 18. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-18 00:00:00'} = 170 19. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-19 00:00:00'} = 171 20. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-20 00:00:00'} = 172 21. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-21 00:00:00'} = 173 22. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-22 00:00:00'} = 174 23. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-23 00:00:00'} = 175 24. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-24 00:00:00'} = 176 25. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-25 00:00:00'} = 177 26. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-26 00:00:00'} = 178 27. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-27 00:00:00'} = 179 28. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-28 00:00:00'} = 180 29. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-29 00:00:00'} = 181 30. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-30 00:00:00'} = 182 31. {ts > '2003-05-01 00:00:00'} - {ts '2003-10-31 00:00:00'} = 183 > > hth ... tony > > -----Original Message----- > From: Johan Steenkamp [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 20, 2003 8:50 PM > To: CF-Talk > Subject: DateDiff() broken in 6.1 (Bug?) > > > Can anyone else confirm that the datediff() function is broken in MX > 6.1 compared with 6.0? > > Simple test (code below) - output will show two consecutive dates with > a difference of 157 days i.e: ... > 156 > 157 > 157 > 158 > ... > > where it should be > ... > 156 > 157 > 158 > 159 > ... > > Problem not evident on 6.0 (Windows or Linux). > > > <!--- test code ---> > <cfset year = 2003> > > <cfset date1 = createdatetime(year,5,1,0,0,0)> > > <cfloop index="i" from="1" to="31"> > <cfset date2 = createdatetime(year,10,i,0,0,0)> <cfoutput>#i#. > #date1# - #date2# = #datediff("d",date1,date2)#</cfoutput><br> > </cfloop> > > > -------------------------------------------- > Johan Steenkamp > www.assetnow.com > -------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
