Try wrapping it in a CreateODBCDateTime(Now()) or lookup the format of the field on the mySQL site and DateFormat() or see if mySQL has an inbuilt version of Now() if all you are going to store is now()
HTH On Tue, 4 Jan 2005 11:19:06 -0500, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Does anyone know the proper default value for a DateTime > Field in mySQL? > > I tried using Now() and it converts it to: 0:00:00 0:00:00 > Which is illegal value or call or something like that. > > I want that to be triggered as the default datetime when > A record is added to the table rather than setting the > field's value within the query itself. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:141500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
