This space is archived

For current information please use the current ExamSys documentation

Formatting Dates

Owned by Joseph Baxter
Mar 20, 2015

MySQL

There are four variables that can be used to format a date within a MySQL query:

  • $cfg_short_date = '%d/%m/%y';
  • $cfg_long_date = '%d/%m/%Y';
  • $cfg_long_date_time = '%d/%m/%Y %H:%i';
  • $cfg_short_date_time = '%d/%m/%y %H:%i';

The above date formats can be altered in /config/config.inc.php. To use within code they can be picked up through the configObject:

$result = $mysqli->prepare("SELECT DATE_FORMAT(start_date, '" . $configObject->get('cfg_long_date_time') . "') FROM properties WHERE paper_type = '2';

Note

Any changes to the date format config items above should be reflected in the following config item used by the jquery table sorter:

  • $cfg_tablesorter_date_time = 'uk';