Date and time

The following functions are used with date and time.

CDatabase::CharToDateFunction
CDatabase::DateToCharFunction
CDatabase::CurrentDateFunction
CDatabase::CurrentTimeFunction
CDataBase::DateFormatToPHP
CDataBase::FormatDate
ConvertDateTime
MakeTimeStamp
ConvertTimeStamp
CDataBase::IsDate
CDataBase::CompareDates
AddToTimeStamp
getmicrotime

The following format specifiers can be used with date and time:

YYYY - year;
MM - month;
DD - day;
HH - hours;
MI - minutes;
SS - seconds.

Methods for use with SQL queries

CDatabase::CharToDateFunction - returns a date and time value converted to the database SQL format.

<?
$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__);
?>

CDatabase::DateToCharFunction - converts the database SQL format to a date and time string.

<?
$strSql = "
    SELECT 
        ID, 
        ".$DB->DateToCharFunction("DATE_CREATE")." DATE_CREATE 
    FROM 
        my_table
    ";
$rs = $DB->Query($strSql, false, $err_mess.__LINE__);
?>

CDatabase::CurrentDateFunction - used to obtain the SQL function returning the current date.

<?
$strSql = "
    SELECT 
        ID 
    FROM 
        my_table 
    WHERE 
        DATE_CREATE<=".$DB->CurrentDateFunction()
    ";
$rs = $DB->Query($strSql, false, $err_mess.__LINE__);
?>

CDatabase::CurrentTimeFunction - returns the SQL string used to obtain the current time in the database format.

<?
$strSql = "
    UPDATE my_table SET 
         TIME_CHANGE=".$DB->CurrentTimeFunction()."
    WHERE 
         ID=45
    ";
$Query($strSql, false, "FILE: ".__FILE__."<br>LINE: ".__LINE__);
?>

Format conversion

CDataBase::DateFormatToPHP - converts the date and time format allowed by the site settings to the PHP format.
```
<?
echo $DB->DateFormatToPHP("DD.MM.YYYY HH:MI:SS"); // d.m.Y H:i:s
?>
```

CDataBase::FormatDate - converts the date from the source format into another.

<?
echo $DB->FormatDate("31.12.2005", "DD.MM.YYYY", "YYYY-MM-DD"); // 2005-12-31
?>

ConvertDateTime - takes the date and time specified in the format of the current site and converts it to an arbitrary format.
```
<?
echo ConvertDateTime("25.12.2003", "YYYY-MM-DD", "ru"); // 2003-12-25
?>
```

MakeTimeStamp - converts the time to the Unix format.

<?
echo MakeTimeStamp("07.04.2005 11:32:00", "DD.MM.YYYY HH:MI:SS"); // 1112862720
?>

ConvertTimeStamp - converts time from the Unix format to a string in the site format.

<?
echo ConvertTimeStamp(mktime(0, 0, 0, 10, 25, 2003), "SHORT", "ru"); // 25.10.2003
?>

Service functions

CDataBase::IsDate - checks the date for validity.

<?
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
?>

CDataBase::CompareDates - compares two dates.

<?
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
?>

AddToTimeStamp - adds the specified time span to a date in Unix format.

<?
$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
?>

getmicrotime - returns the current time in Unix format.
```
<?
echo getmicrotime(); // 1115454720
?>
```