date formatting issues???

lukeurtnowski

OK, I have everything figured (thanks to this forum), on one of my pages I have a form where users enter a date of a certain activity (mm/dd/yyyy) format. The problem is this, when the date is written to the mysql table, it goes in the format (yyyy-mm-dd). The date is not being transferred to the table in the correct form once its format is altered, do you know how to correct this?
Thanks

planetsim

SELECT DATE_FORMAT(datefield, '%c/%e/%Y') FROM mytbl

Is an example of how you would accomplish it of course you will need to change the datefield and mytbl

lukeurtnowski

Well, this time around im inserting a record into a table (some how alter this so tha variable $activity_date is inserted in the correct format, (for example..., if they enter a date like 01/05/2005, it shows up in the table like 2001-05-20???Where does that # come from, shouldn't it be 2005-01-05?

INSERT into activity VALUES('',''$activity_date', '$activity_description','$c_id','$next_step')

planetsim

You should validate the date into the correct format, MySQL only interprets what it gets. And as its in the incorrect format it tries to validate it into the correct format which is of course yyyy-mm-dd

Now if the date is an invalid format you have two things you can do, create a function to correct it as best as possible before it goes into the database or alert the user that they entered the date in the incorrect format.