X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fdbm.php;h=fedc2e4fdb23881e694a7b2cbb3e218f5844614d;hb=bb59f105e719ef420a5cd0dcacfa3e3955dc5a0c;hp=62ebb1af082526b8d12ea6eb4154688ffbedba86;hpb=39136b6485834906b86269a3df2b6eeb9ed73d13;p=friendica.git diff --git a/include/dbm.php b/include/dbm.php index 62ebb1af08..fedc2e4fdb 100644 --- a/include/dbm.php +++ b/include/dbm.php @@ -86,5 +86,29 @@ class dbm { public static function esc_array(&$arr, $add_quotation = false) { array_walk($arr, 'self::esc_array_callback', $add_quotation); } + + /** + * Checks Converts any date string into a SQL compatible date string + * + * @param string $date a date string in any format + * @return string SQL style date string + */ + public static function date($date = 'now') { + $timestamp = strtotime($date); + + // Workaround for 3.5.1 + if ($timestamp < -62135596800) { + return '0000-00-00 00:00:00'; + } + + // The above will be removed in 3.5.2 + // The following will then be enabled + // Don't allow lower date strings as '0001-01-01 00:00:00' + //if ($timestamp < -62135596800) { + // $timestamp = -62135596800; + //} + + return date('Y-m-d H:i:s', $timestamp); + } } ?>