CODEWITHSUNDEEP
phpstring
Kirk Ouimet
Kirk Ouimet

Reputation: 28364

Fast way in PHP to check if a value is in MySQL datetime format?

Does anyone know if there is a built in or quick function to check if a string is a MySQL datetime format? Here is an example:

2038-01-19 03:14:07

http://dev.mysql.com/doc/refman/5.0/en/datetime.html

Upvotes: 14

Views: 7615

Answers (2)

Mohammed Farag
Mohammed Farag

Reputation: 335

I loved the answer by epicdev, however, the class seems to only validate the format, a date like 2015-18-39 is still valid for it and is converted to 2016-07-09 instead of rejecting the invalid day/month A slight change to it is to double check that the date parsed is still the same as the date entered.

function proposed by glavic at gmail dot com on php.net documentation

function validateDate($date, $format = 'Y-m-d H:i:s')
{
    $d = DateTime::createFromFormat($format, $date);
    return $d && $d->format($format) == $date;
}

function was copied from this answer or php.net

Upvotes: 12

epicdev
epicdev

Reputation: 922

You can try DateTime::createFromFormat('Y-m-d H:i:s', '2038-01-19 03:14:07') and see if it returns false. http://www.php.net/manual/en/datetime.createfromformat.php

Upvotes: 15

Related Questions