Link to home
Start Free TrialLog in
Avatar of phillystyle123
phillystyle123Flag for United States of America

asked on

dateformat not working quite right

value="<CFOUTPUT>#DateFormat(Now(),"mm/dd/yyyy")#</CFOUTPUT>"

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??
Avatar of jyokum
jyokum
Flag of United States of America image

how are you inserting it into the database?
ASKER CERTIFIED SOLUTION
Avatar of jyokum
jyokum
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial