Proper formatting for writing to the DateTime field in mySQL

[gigasaurus]

I need to timestamp or set particular dates which I will be writing to a datetime field in a mySQL database.

The format for that looks like this: 2009-01-23 01:01:01

I am able to write to the field by formatting like this: dateformat(Now(), "yyyy-mm-dd hh:mm:ss")

The problem is the "minutes" take on the "month" value (because I'm using the letter "m" in both places). Is there another letter other than "m" that I should be using for minutes? I have a reference book that says "n" but that didn't work. I'll attach the basic code below.

[-__cfSearching__-]

> writing to a datetime field

Then don't insert a string, insert a valid date/time object. The now() function returns a date/time object. Just add a cfqueryparam:

<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">

> The problem is the "minutes" take on the "month" value (because I'm using the letter "m" in both places

If you check the documentation, DateFormat only handles the date portion. To format the time portion, you need to use TimeFormat.

[Dan_Bracuk]

Better yet, if mysql has a function that returns the current date and time, use it.