PHP to change date format

Einar

I am new to php coding and this may therefor seem like a silly question.

The thing is that i have a question about whether I can take a date that is put in a input field by a user in the format dd.mm.yyyy and convert it into the MySql format, yyyy-mm-dd, directly as the information that have been inserted are submitted to the database.

If there is a solution I would be happy to hear from you.

Thanks in advance,
Einar

devinemke

$date = '01/24/2006';
echo date('Y-m-d', strtotime($date)); // outputs 2006-01-24

Einar

Is it then possible for me to include this code in my SQL insert command?

devinemke

Einar wrote:
Is it then possible for me to include this code in my SQL insert command?

$date = '01/24/2006'; 
$date = date('Y-m-d', strtotime($date));
$sql = "INSERT INTO table SET date = '$date'";

Einar

I did try both of the methods described above and had no luck. It did not seem to work.

Any other suggestions?

Regards,
Einar

devinemke

Einar wrote:
I did try both of the methods described above and had no luck.

how? post your code.

Houdini

Run the entered date through this little code test and it will format it then just use the $regs[] values in your query.

$date ="31.01.2006";
if (ereg ("([0-9]{1,2}).([0-9]{1,2}).([0-9]{4})", $date, $regs)) {
   echo "$regs[3]-$regs[2]-$regs[1]";
} else {
   echo "Invalid date format: $date";
   }

Try it with different dates from wherever you get your input, you can use the ereg above to manipulate the date how you want it, but MySQL will accept a date as follows 2006 01 23 2006/01/23 2006.01.23 or 2006-01-23