Insert DATETIME to MySQL

Hello,
I would like to make an insert to a mysql DB to a DATETIME field using the SQL now() function.

$WA_fieldNamesStr = "cname|ccompany|cphone|cemail|ccomments|cinsertdate";
  $WA_fieldValuesStr = "".((isset($_POST["fld_name"]))?$_POST["fld_name"]:"")  ."" . "|" . "".((isset($_POST["fld_company"]))?$_POST["fld_company"]:"")  ."" . "|" . "".((isset($_POST["fld_phone"]))?$_POST["fld_phone"]:"")  ."" . "|" . "".((isset($_POST["fld_email"]))?$_POST["fld_email"]:"")  ."" . "|" . "".((isset($_POST["fld_comments"]))?$_POST["fld_comments"]:"")  ."" . "|" . "now()";

returns an error of:

" Incorrect datetime value: 'now()' for column 'cinsertdate' at row 1 "

Why is this? Allowing SQL to set the date is the most efficient means but for some reason this is not happening.

btw, I realize I can use a hidden field formatted in the expected SQL DATETIME format such as:

<input name="hiddenDateTime" type="hidden" id="hiddenDateTime" value="<?php echo date('Y-m-d H:i:s') ?>" />

But it seems the now() sql function is more efficient and I wonder if there is something available to achieve this goal.

You don't need a hidden form element. You can set the value to:

<?php echo(date('Y-m-d H:i:s')); ?> directly in the column binding.

I don't think DW will allow you to reference mySQL functions. It doesn't pass the sql injection checks that are in place. Quotes are put around all date fields, so I just don't think the NOW() technique will work.

Thanks for that come back Ray.