/**
* @return string
*/
public static function getDatetimeExpressionTemplate()
{
if (self::$datetimeTemplate === null) {
$helper = Application::getConnection()->getSqlHelper();
$format = Context::getCurrent()->getCulture()->getDateTimeFormat();
$datetimeFieldName = '#FIELD#';
$datetimeField = $datetimeFieldName;
if (\CTimeZone::Enabled()) {
$diff = \CTimeZone::GetOffset();
if ($diff != 0) {
$datetimeField = $helper->addSecondsToDateTime($diff, $datetimeField);
}
unset($diff);
}
self::$datetimeTemplate = str_replace(array('%', $datetimeFieldName), array('%%', '%1$s'), $helper->formatDate($format, $datetimeField));
unset($datetimeField, $datetimeFieldName, $format, $helper);
}
return self::$datetimeTemplate;
}
