Hi Claude, obviously there's some history to 'createODBCdate' and the
function name says it all. 

I was wondering - now CFMX uses JDBC is there any problems using
createODBCdate with JDBC connections? Is there a better practice,
alternative functions? Or does CF just handle it all? 

Cheers,
AS 

-----Original Message-----
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 25 January 2006 9:54 AM
To: CF-Talk
Subject: Re: Date Formats

 >>am sure I haven't had that problem with other databases thought.

Actually, it depends on the date.
If the date cannot be interpreted as a valid date in American format, CF 
will assume it is in European and convert it correctly.
Problem arrises when the date format is ambiguous, like 10/12/2005. This 
date is valid in American format, and CF has no way,
nor any reason to supose it could be in European format.
So actually you will only have a problem for the first 12 days of any 
month, except the first of jan, the 2nd of feb, etc.
AND somebody discovers something is wrong, which is not 100% of times ;-)

-- 
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230655
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to