public function DatabaseConnection_mysql::dateFormatSql

Format a date field.

Parameters

string $format: A format string for the result, like 'Y-m-d H:i:s' .

string $field: The real table and field name, like 'tablename.fieldname' .

Return value

string: An appropriate SQL string for the db type and field type.

Overrides DatabaseConnection::dateFormatSql

File

drivers/database_mysql/database.inc, line 677

Database interface code for MySQL database servers.

Class

DatabaseConnection_mysql

Code

public function dateFormatSql($field, $format) {
  $replace = array(
    'Y' => '%Y',
    'y' => '%y',
    'M' => '%b',
    'm' => '%m',
    'n' => '%c',
    'F' => '%M',
    'D' => '%a',
    'd' => '%d',
    'l' => '%W',
    'j' => '%e',
    'W' => '%v',
    'H' => '%H',
    'h' => '%h',
    'i' => '%i',
    's' => '%s',
    'A' => '%p',
  );
  $format = strtr($format, $replace);
  return "DATE_FORMAT($field, '$format')";
}