Has anyone else found a change in behaviour between
createodbcdatetime() on ColdFusion 6.1 and ColdFusion 7.1 that affects
folks not using USA locale.
I'm return a list of files in a directory with cfdirectory - pretty
standard and i want to compare the age of the files to the current
date, If i then flip the date with createodbcdatetime() is appears on
cf7.1 that it's ignoring the locale.
On 6.1 I see the following (first column is raw, second is
createodbcdatetime() resultant)
06 April 2005 08:16:51 o'clock BST {ts '2005-04-06 08:16:51'}
29 March 2005 11:12:38 o'clock BST {ts '2005-03-29 11:12:38'}
15 June 2005 11:14:20 o'clock BST {ts '2005-06-15 11:14:20'}
10 November 2005 08:22:58 o'clock GMT {ts '2005-11-10 08:22:58'}
On 7.1 I see the following;
06/04/05 08:16 {ts '2005-06-04 08:16:00'}
29/03/05 11:12 {ts '2029-03-05 11:12:00'}
15/06/05 11:14 {ts '2015-06-05 11:14:00'}
10/11/05 08:22 {ts '2005-10-11 08:22:00'}
So my file 29 March 2005 has gone through a time machine and ended up
in 2029!! It would seem that CF7.1 is ignoring the server locale and
using USA format for dates.
Both instances are running on the same computer - both report English
(UK) if you do a getlocale()
Any ideas?
thanks,
john
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224294
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
