Doug Brown wrote: > figured it out. I guess mySql does not like dateFormat(now(),"mm/dd/yyyy) > and prefers dateFormat(Now(),"yyyy/dd/mm") Just some of the things I am > goping to have to get use to I suppose.
formatting of the dates only matters if you're trying to insert them as strings - you do not want to be doing that. Use cfqueryparam or createODBCDateTime. Don't use '2006-09-08 21:47:00' Alternatively, if you want to insert the current datetime just use the MySQL function NOW() Ie... insert into sometable ( dateField ) values ( Now() ); No pound signs, that's a mysql function, not a CF function. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4