http://msdn.microsoft.com/en-us/library/bb330962%28SQL.90%29.aspx
Midway down the page is a table of regarding internationalization of dates. There is also a default setting in the database configuration for the date format. On Wed, May 12, 2010 at 6:19 AM, Mike Kear <afpwebwo...@gmail.com> wrote: > > 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/cf-talk/message.cfm/messageid:333606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm