Date and time

In MV, date and time are stored in model fields of the date and date_time types. In the database, they are stored in the SQL format of the form 'yyyy-mm-dd hh:mm:ss'. When entering and retrieving data from the database, it is necessary to use special methods to convert the values ​​to the desired format, using the I18n class, which is also responsible for internationalization and localization.

The main date format is specified in the localization file, which is located in the /adminpanel/i18n/[region]/locale.php folder.

I18n class methods

• formatDate($date [,$format]) - converts the date from the SQL format ‘yyyy-mm-dd hh:mm:ss’ to the current format specified in the localization file, if you pass an optional parameter in the form of 'only-date', it will return only the date, and if in the form of 'no-seconds', the seconds will be discarded. Also, the date format can be passed in a form similar to the PHP function date(), for example ‘d-m-Y’.
• dateForSQL($date) - converts the date from the current format to the SQL format, for writing to the database.
• getCurrentDate([$sql_format]) - returns the current date in accordance with the localization format. If you pass an optional parameter as 'SQL', the current date will be returned in SQL format.
• getCurrentDateTime([$sql_format]) - returns the current date and time according to the localization format.
• timestampToDate($timestamp) - converts a timestamp to a date according to the localization format. If you pass an optional parameter as 'SQL', the current date will be returned in SQL format.
• getMonth($number) - returns the name of the month by its number, for example 'February', 'March'.
• getMonthCase($number) - returns the name of the month in the genitive case, for example 'February', 'March'.
• getWeekDayName($date) - returns the name of the day of the week, for example 'Tuesday', 'Thursday'

//Find news by id
$record = $mv -> news -> find(32);

//Output date, converting SQL format
echo I18n::formatDate($record -> date);

//Format date
echo I18n::formatDate($record -> date, 'd/m/Y'));

//Output date and time without seconds
echo I18n::formatDate($record -> date, 'no-seconds');

//Output only date, without time (for date_time)
echo I18n::formatDate($record -> date, 'only-date');

//Output the day of the week
echo I18n::getWeekDayName($record -> date);

//Pass the current date into the record
$record -> date = I18n::getCurrentDateTime();
$record -> update();

//Count the number of news items for the current day
$number = $news -> countRecords(['date' => I18n::getCurrentDate()]);

//Converting a date from SQL to the format 'November 12, 2023'
public function formatDate($date)
{
    $date = explode('-', $date);
    return $date[2].' '.I18n::getMonthCase(intval($date[1])).' '.$date[0];
}