mysql_to_rfc3339() – Function | Developer.WordPress.org

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

Description

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

Despite historical function name, the output does not conform to RFC3339 format, which must contain timezone.

string Date formatted for ISO8601 without time zone.

function mysql_to_rfc3339( $date_string ) {
	return mysql2date( 'Y-m-d\TH:i:s', $date_string, false );
}

Uses	Description
mysql2date()`wp-includes/functions.php`	Converts given MySQL date string into a different format.

Used by	Description
WP_REST_Templates_Controller::prepare_item_for_response()`wp-includes/rest-api/endpoints/class-wp-rest-templates-controller.php`	Prepare a single template output for response
WP_REST_Revisions_Controller::prepare_date_response()`wp-includes/rest-api/endpoints/class-wp-rest-revisions-controller.php`	Checks the post_date_gmt or modified_gmt and prepare any post or modified date for single post output.
WP_REST_Posts_Controller::prepare_date_response()`wp-includes/rest-api/endpoints/class-wp-rest-posts-controller.php`	Checks the post_date_gmt or modified_gmt and prepare any post or modified date for single post output.
WP_REST_Comments_Controller::prepare_item_for_response()`wp-includes/rest-api/endpoints/class-wp-rest-comments-controller.php`	Prepares a single comment output for response.

Version	Description
4.4.0	Introduced.