Date and Time formats management logic
PHP CRUD Tutorial

---

The different Date and Time formats

List of the date, datetime and time formats used in PHP CRUD Generator

Pages	Usage	Language	Format
READ lists	Human readable date translated according to the user language	PHP with intl extension enabled	ICU *
READ lists	Human readable date NOT translated	PHP without intl extension enabled	PHP date format **
CREATE / UPDATE forms	Datepicker plugins	Javascript	Pickadate plugin formats ***
PHP Objects	Database date, time and datetime fields	PHP/MySQL	Y-m-d H:i:s

^*ICU - https://unicode-org.github.io/icu-docs/apidoc/released/icu4c/classSimpleDateFormat.html#details

^**PHP date formats list: https://www.php.net/manual/en/function.date.php

^***PHP date formats list: https://amsul.ca/pickadate.js/date/

---

Date and Time formats management logic

The Generator and Admin panel date & time formats

1. When you set a date / time format in a generator READ list, your choice is stored in internal file (generator/database/phpcg/[your_table].json).

   The format stored is the Javascript format

   The admin form's date & time pickers will use this format.

2. The Javascript format is converted to PHP ICU by generator/class/generator/TemplatesUtilities.php

   The function is pickerdateToPhpdate($pickerdate)

3. The item class builds the object value using the PHP/MySQL format (no format conversion)

4. the READ list TWIG template calls the formatDate($date, $format) function in vendor/twig/twig/lib/Twig/Extension/CrudTwigExtension.php

   The given $date is in PHP/MySQL format and can be a date, a time or a datetime.

   The given $format is the ICU format.

   • if PHP intl extension is enabled it'll show the date translated according to your languages settings with IntlDateFormatter::formatObject() using Locale::getDefault()
   • if PHP intl extension is not enabled it converts the ICU date / time to the classic PHP date format

Random datetime formats examples

The datetimes below are generated from a random format using the same logic as the CRUD Generator.

$pickerdate

yyyy m dd hh i a

$icu_format

yyyy M dd hh m a

$icu_date

2020 4 08 10 49 am

$php_format

Y n d h i a

$php_date

2020 4 08 10 49 am

---

$pickerdate

yyyy m d HH i A

$icu_format

yyyy M d HH m a

$icu_date

2020 4 8 10 49 am

$php_format

Y n j H i a

$php_date

2020 4 8 10 49 am

---

$pickerdate

yyyy mmmm dd h i A

$icu_format

yyyy MMMM dd h m a

$icu_date

2020 April 08 10 49 am

$php_format

Y F d g i a

$php_date

2020 April 08 10 49 am

---

$pickerdate

yyyy mmm dddd H i a

$icu_format

yyyy MMM eeee H m a

$icu_date

2020 Apr Wednesday 10 49 am

$php_format

Y M l G i a

$php_date

2020 Apr Wednesday 10 49 am

---

$pickerdate

yy m dd h i a

$icu_format

yy M dd h m a

$icu_date

20 4 08 10 49 am

$php_format

y n d g i a

$php_date

20 4 08 10 49 am

---

$pickerdate

yy mmmm d h i A

$icu_format

yy MMMM d h m a

$icu_date

20 April 8 10 49 am

$php_format

y F j g i a

$php_date

20 April 8 10 49 am

---

$pickerdate

yyyy mmmm dd hh i A

$icu_format

yyyy MMMM dd hh m a

$icu_date

2020 April 08 10 49 am

$php_format

Y F d h i a

$php_date

2020 April 08 10 49 am

---

$pickerdate

yyyy mm dd h i a

$icu_format

yyyy MM dd h m a

$icu_date

2020 04 08 10 49 am

$php_format

Y m d g i a

$php_date

2020 04 08 10 49 am

---

$pickerdate

yyyy mmmm ddd HH i a

$icu_format

yyyy MMMM eee HH m a

$icu_date

2020 April Wed 10 49 am

$php_format

Y F D H i a

$php_date

2020 April Wed 10 49 am

---

$pickerdate

yyyy mmm dddd hh i A

$icu_format

yyyy MMM eeee hh m a

$icu_date

2020 Apr Wednesday 10 49 am

$php_format

Y M l h i a

$php_date

2020 Apr Wednesday 10 49 am

---

Advanced

• Date and Time formats management logic

PHP CRUD tutorial main page