1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| define('USER_DATE', 'd/m/Y');
define('DB_DATE', 'Y-m-d');
define('DB_DATE_235959', 'Y-m-d 23:59:59');
define('USER_DATETIME', 'd/m/Y H:i:s');
define('DB_DATETIME', 'Y-m-d H:i:s');
function dateToString($date, $format) {
if (empty($date)) return '';
return $date->format($format);
}
function stringToDate($string, $format) {
$string = trim($string);
return DateTime::createFromFormat($format, $string);
}
function dbToUserDate($date) {
$date = dateToString(stringToDate($date, DB_DATE), USER_DATE);
return $date == '30/11/-0001' ? '' : $date;
}
function dbToUserDateTime($date) {
$date = dateToString(stringToDate($date, DB_DATETIME), USER_DATE);
return $date == '30/11/-0001' ? '' : $date;
} |