private function get_sql_date($date_value)
{
return DateTool::date_to_sql($date_value);
}
public static function datetime_to_sql($date, $locale = null, $force_datetime = false)
{
$date = trim($date);
$format = DateTool::get_datetime_format($locale);
/*
* Check if the $date should be parsed as a date and not a datetime
*/
if (!$force_datetime && stripos($format, ' ') !== false && stripos($date, ' ') === false) {
return DateTool::date_to_sql($date, $locale);
} else {
if ($force_datetime && stripos($date, ' ') === false) {
$date .= ' 00:00:00';
}
$format = str_replace('Y', '%Y', $format);
$format = str_replace('m', '%m', $format);
$format = str_replace('d', '%d', $format);
$format = str_replace('H', '%H', $format);
$format = str_replace('i', '%M', $format);
$format = str_replace('s', '%S', $format);
$date_array = strptime($date, $format);
if ($date_array !== false) {
$day = sprintf("%02d", $date_array['tm_mday']);
$month = sprintf("%02d", $date_array['tm_mon'] + 1);
$year = 1900 + $date_array['tm_year'];
$hour = sprintf("%02d", $date_array['tm_hour']);
$min = sprintf("%02d", $date_array['tm_min']);
$sec = sprintf("%02d", $date_array['tm_sec']);
return $year . '-' . $month . '-' . $day . ' ' . $hour . ':' . $min . ':' . $sec;
} else {
return null;
}
}
}
