A WordPress-centric search engine for devs and theme authors



mysql_to_rfc3339 ›

Since4.4.0
Deprecatedn/a
mysql_to_rfc3339 ( $date_string )
Parameters:
  • (string) $date_string Date string to parse and format.
    Required: Yes
Returns:
  • (string) Date formatted for ISO8601/RFC3339.
Defined at:
Codex:

Parses and formats a MySQL datetime (Y-m-d H:i:s) for ISO8601/RFC3339.

Explicitly strips timezones, as datetimes are not saved with any timezone information. Including any information on the offset could be misleading.



Related Functions:

Source

function mysql_to_rfc3339( $date_string ) {
	$formatted = mysql2date( 'c', $date_string, false );

	// Strip timezone information
	return preg_replace( '/(?:Z|[+-]\d{2}(?::\d{2})?)$/', '', $formatted );
}