Esempi in PHP per Bitrix\Main\Type DateTime::getOffset

Esempio n. 1

File: mssqlsqlhelper.php Progetto: k-kalashnikov/geekcon_new

 public function getDateTimeToDbFunction(\Bitrix\Main\Type\DateTime $value, $type = \Bitrix\Main\Type\DateTime::DATE_WITH_TIME)
 {
     $customOffset = $value->getOffset();
     $serverTime = new \Bitrix\Main\Type\DateTime();
     $serverOffset = $serverTime->getOffset();
     $diff = $customOffset - $serverOffset;
     $valueTmp = clone $value;
     $valueTmp->sub(new \DateInterval(sprintf("PT%sS", $diff)));
     $format = $type == \Bitrix\Main\Type\DateTime::DATE_WITHOUT_TIME ? "Y-m-d" : "Y-m-d H:i:s";
     $date = "CONVERT(datetime, '" . $valueTmp->format($format) . "', 120)";
     return $date;
 }