dateformat not working quite right


this looks perfect in the form field. but in my mysql database i'm getting this (instead of 11/9/2003):

9/20/2011 3:00:00 AM

the field in the database is set to datetime format.  any ideas??
Who is Participating?
jyokumConnect With a Mentor Commented:
should be using CFQUERYPARAM. something like

INSERT INTO tablename (dateColumn)
VALUES (<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">)
how are you inserting it into the database?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.