W3cubDocs

/WordPress

mysql_to_rfc3339( string $date_string )

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.

Parameters

$date_string

(string) (Required) Date string to parse and format.

Return

(string) Date formatted for ISO8601 without time zone.

Source

File: wp-includes/functions.php 

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

Uses

Uses Description
wp-includes/functions.php: mysql2date()

Convert given MySQL date string into a different format.

Used By

Used By Description
wp-includes/rest-api/endpoints/class-wp-rest-revisions-controller.php: WP_REST_Revisions_Controller::prepare_date_response()

Checks the post_date_gmt or modified_gmt and prepare any post or modified date for single post output.
wp-includes/rest-api/endpoints/class-wp-rest-posts-controller.php: WP_REST_Posts_Controller::prepare_date_response()

Checks the post_date_gmt or modified_gmt and prepare any post or modified date for single post output.
wp-includes/rest-api/endpoints/class-wp-rest-comments-controller.php: WP_REST_Comments_Controller::prepare_item_for_response()

Prepares a single comment output for response.

Changelog

Version Description
4.4.0 Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/mysql_to_rfc3339