Date Format when inserting data

[scadran]

I am getting a date entry through POST by a form byt the format enetered by the user is 'dd/mm/yy' .... how could i use MYSQL PHP syntax to insert the proper format as it is default in the table in my database. which function is it?

Rgards

[paul2463]

<?php
$date = "14/03/07";
$datearray = explode("/", $date); //explode the date via the "/"
$newdate = "$datearray[1]/$datearray[0]/$datearray[2]"; //rearrange the date for the strtotime format to work properly
$newerdate = strtotime($newdate); //create the timestamp
$insertdate("Y-m-d", $newerdate); //create the date object from the timestamp in mysql format
?>

[chigley]

<?php

$date = "01/01/01";

$newdate = date("Y-m-d",strtotime($date));

echo $newdate;

?>

[Barand]

~chigley,

Unfortunately, strtotime does not recognise dd/mm/yy format . Try 25/12/07

 

<?php
$date = '25/12/07';
list ($d,$m.$y) = explode ('/', $date);
$dbdate = "$y-$m-$d";              // write this to the db if you have DATE or DATETIME field
$tstamp = strtotime($dbdate );   // write this to the db if you have timestamp field