The following functions are used with date and time.
The following format specifiers can be used with date and time:
<? $strSql = " SELECT ID FROM my_table WHERE DATE_CREATE <= ".$DB->CharToDateFunction("10.01.2003 23:59:59")." "; $rs = $DB->Query($strSql, false, $err_mess.__LINE__); ?>
<? $strSql = " SELECT ID, ".$DB->DateToCharFunction("DATE_CREATE")." DATE_CREATE FROM my_table "; $rs = $DB->Query($strSql, false, $err_mess.__LINE__); ?>
<? $strSql = " SELECT ID FROM my_table WHERE DATE_CREATE<=".$DB->CurrentDateFunction() "; $rs = $DB->Query($strSql, false, $err_mess.__LINE__); ?>
<? $strSql = " UPDATE my_table SET TIME_CHANGE=".$DB->CurrentTimeFunction()." WHERE ID=45 "; $Query($strSql, false, "FILE: ".__FILE__."<br>LINE: ".__LINE__); ?>
<? echo $DB->DateFormatToPHP("DD.MM.YYYY HH:MI:SS"); // d.m.Y H:i:s ?>
<? echo $DB->FormatDate("31.12.2005", "DD.MM.YYYY", "YYYY-MM-DD"); // 2005-12-31 ?>
<? echo ConvertDateTime("25.12.2003", "YYYY-MM-DD", "ru"); // 2003-12-25 ?>
<? echo MakeTimeStamp("07.04.2005 11:32:00", "DD.MM.YYYY HH:MI:SS"); // 1112862720 ?>
<? echo ConvertTimeStamp(mktime(0, 0, 0, 10, 25, 2003), "SHORT", "ru"); // 25.10.2003 ?>
<? echo $DB->IsDate("12.10.2005 22:34:15", "DD.MM.YYYY HH:MI:SS") ? "OK" : "ERROR"; // OK echo $DB->IsDate("12.13.2005 22:34:15", "DD.MM.YYYY HH:MI:SS") ? "OK" : "ERROR"; // ERROR echo $DB->IsDate("12.13..2005 ABS", "DD.MM.YYYY HH:MI:SS") ? "OK" : "ERROR"; // ERROR ?>
<? echo $DB->CompareDates("01.01.2005", "01.01.2007"); // -1 echo $DB->CompareDates("01.01.2007", "01.01.2005"); // 1 echo $DB->CompareDates("01.01.2007", "01.01.2007"); // 0 ?>
<? $stmp = MakeTimeStamp("07.04.2005 11:32:00", "DD.MM.YYYY HH:MI:SS"); $stmp = AddToTimeStamp(array("DD" => -1, "MM" => 1), $stmp); // 1115454720 echo date("d.m.Y H:i:s", $stmp); // 06.05.2005 11:32:00 ?>
<? echo getmicrotime(); // 1115454720 ?>
© 2001-2005 Bitrix | Bitrix Site Manager - Content Management & Portal Solutions |