inserting date into MySql Database

[khotwheels]

I am trying to insert the current date into a MySql database. I know that the
date format for MySql is yyyy-mm-dd . So far I have tried to insert it like
this:
<cfquery datasource="xxx" username="xxx" password="xxx">
INSERT INTO Time (Time)
VALUES ('#CreateODBCDate(yyyy,mm,dd)#' )
</cfquery>
The error I get is that the function takes one parameter.
Any help someone could offer would be much apreciated.

[SafariTECH]

#CreateODBCDate("#NOW()#")#

It takes an existing date and makes a properly formatted date for an ODBC
compliant database, so long as you are inserting it into an actual date field
in the DB it should work

[khotwheels]

I am trying to insert the date (yyyy-mm-dd) not time. I should have named the
field differently. I did try your suggestion and it gave me the following
error.
Error Executing Database Query - Syntax error or access violation: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '2005-09-01'}')' at line 3
I thought perhaps I should take out the hash symbols surrounding the NOW
function but it gave me the same error.

[khotwheels]

I took the quotes out around the hash symbols and it worked. Thank you very much for your help.