Mark Flewellen wrote: > This occurs for me on Windows and Linux Servers, Coldfusion and Blue Dragon.
not a bug then, behavior. > I do an insert into the mysql database (version 3.** and 4.1). Inserting into > the database using <cfqueryparam value="#LsDateFormat(form.news_date)#" i see. you're inserting a localized date string instead of a datetime object. i would guess that the db's locale is en_GB, as i get "10 November 2006" for now() using en_GB as the cf locale--my sql server's db server's en_US locale. can mySQL interpret date strings? if so maybe try <cfqueryparam value="#LsDateFormat(form.news_date,'LONG')#"> but you'd be better off ditching the localized strings & stick w/the cf datetime object or even better java epoch offsets (as you're going to eventually get bit by cf's "all datetimes are server datetimes" timezone issue). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
