mysql2date ( $format, $date, $translate = true )

  • (string) format Format of the date to return.
  • (string) date Date string to convert.
  • (bool) translate Whether the return date should be translated. Default true.
  • (string|int|bool) Formatted date string or sum of Unix timestamp and timezone offset. False on failure.
Defined at:


Convert given MySQL date string into a different format.`$format` should be a PHP date format string. 'U' and 'G' formats will return a sum of timestamp with timezone offset. `$date` is expected to be local time in MySQL format (`Y-m-d H:i:s`). Historically UTC time could be passed to the function to produce Unix timestamp. If `$translate` is true then the given date and format string will be passed to `wp_date()` for translation.

Related Functions

is_date, translate

Top Google Results

User discussions

wpseek mobile