I'm having trouble figuring out why my database is storing dates in a way i dont want. I hope someone can help.
If I run an insert statement, and the dateentered = <cfqueryparam value="#dateentered#" cfsqltype="CF_SQL_DATE" /> i would have thought that it would store the value '2010-03-31 00:00:00' but it doesnt. When i run a select query on the table the value has been stored as '2010-31-03 00:00:00' (month and day in American format) This means my reports dont find results for the last day of March and all other days are screwed up too. I can't change the reports for a whole lot of reasons, not the least of which is there are bazillions of them. I'd rather force the database to store the date in the format i want. Does anyone know now I can force SQLServer2005 to behave like a good Australian server not an American one and store the dates how we use them? I have also tried using dateentered=#createodbcdate(dateentered)# and that gives the same result. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3346 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
