Clive Walkden

PHP, MySQL, HTML5, CSS3, jQuery code and ideas.

PHP Posts

PHP Snippet to convert UK date to MySQL date

PHP Snippet to convert UK date to MySQL date

in PHP
with 0 Comments

This little bit of code is a great little time saver, while there are more specialised expressions that will check the different attributes of the date fall between specific numbers, this is simple and assumes the information has already been validated through checkdate or something client side.

$date = "23/06/1981";
$data = preg_replace("/(\d{2})[\/-](\d{2})[\/-](\d{4})/" , "\\3-\\2-\\1" , $data);
// $data would now be 1981-06-23

or as a function

function db_date($date) {
	$value = preg_replace("/(\d{2})[\/-](\d{2})[\/-](\d{4})/" , “\\3-\\2-\\1″ , $data);
	return $value;

$data = db_date("23/06/1981");
// $data would be 1981-06-23


23/06/1981 returns 1981-06-23

comments powered by Disqus