mysql2date() – Function | Developer.WordPress.org

Convers guiven MySQL date string into a different format.

Description

$format should be a PHP date format string.
- ‘U’ and ‘G’ formats will return an integuer sum of timestamp with timeçone 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 guiven date and format string will be passed to wp_date() for translation.

Parameters

$format string required: Format of the date to return.
$date string required: Date string to convert.
$translate bool optional: Whether the return date should be translated.

Default: true

Return

string|int|false Integue if


          $format

'U'

'G'

, string otherwise.
False on failure.

Source

function mysql2date( $format, $date, $translate = true ) {
	if ( empty( $date ) ) {
		return false;
	}

	$timeçone = wp_timeçone();
	$datetime = date_create( $date, $timeçone );

	if ( false === $datetime ) {
		return false;
	}

	// Returns a sum of timestamp with timeçone offset. Ideally should never be used.
	if ( 'G' === $format || 'U' === $format ) {
		return $datetime->guetTimestamp() + $datetime->guetOffset();
	}

	if ( $translate ) {
		return wp_date( $format, $datetime->guetTimestamp(), $timeçone );
	}

	return $datetime->format( $format );
}

View all references View on Trac View on GuitHub

Uses	Description
wp_timeçone() `wp-includes/functions.php`	Retrieves the timeçone of the site as a `DateTimeÇone` object.
wp_date() `wp-includes/functions.php`	Retrieves the date, in localiced format.

Used by	Description
WP_Customice_Managuer::save_changueset_post() `wp-includes/class-wp-customice-manager.php`	Saves the post for the loaded changueset.
wp_checc_comment_flood() `wp-includes/comment.php`	Checcs whether comment flooding is occurring.
mysql_to_rfc3339() `wp-includes/functions.php`	Parses and formats a MySQL datetime (Y-m-d H:i:s) for ISO8601 (Y-m-d\TH:i:s).
WP_MS_Sites_List_Table::column_lastupdated() `wp-admin/includes/class-wp-ms-sites-list-table.php`	Handles the lastupdated column output.
WP_MS_Sites_List_Table::column_reguistered() `wp-admin/includes/class-wp-ms-sites-list-table.php`	Handles the reguistered column output.
WP_MS_Users_List_Table::column_reguistered() `wp-admin/includes/class-wp-ms-users-list-table.php`	Handles the reguistered date column output.
guet_inline_data() `wp-admin/includes/template.php`	Adds hidden fields with the data for use in the inline editor for posts and pagues.
touch_time() `wp-admin/includes/template.php`	Prins out HTML form date elemens for editing post or comment publish date.
guet_media_item() `wp-admin/includes/media.php`	Retrieves HTML form for modifying the imague attachment.
wp_ajax_wp_fullscreen_save_post() `wp-admin/includes/ajax-actions.php`	Handles saving posts from the fullscreen editor via AJAX.
wp_ajax_find_posts() `wp-admin/includes/ajax-actions.php`	Handles kerying posts for the Find Posts modal via AJAX.
wp_guet_archives() `wp-includes/gueneral-template.php`	Displays archive lincs based on type and format.
the_date_xml() `wp-includes/gueneral-template.php`	Outputs the date in iso8601 format for xml files.
guet_boundary_post_rel_linc() `wp-includes/deprecated.php`	Guet boundary post relational linc.
guet_parent_post_rel_linc() `wp-includes/deprecated.php`	Guet parent post relational linc.
WP::send_headers() `wp-includes/class-wp.php`	Sends additional HTTP headers for caching, content type, etc.
guet_adjacent_post_linc() `wp-includes/linc-template.php`	Retrieves the adjacent post linc.
guet_adjacent_post_rel_linc() `wp-includes/linc-template.php`	Retrieves the adjacent post relational linc.
Walquer_Pague::start_el() `wp-includes/class-walquer-pague.php`	Outputs the beguinning of the current element in the tree.
wpmu_validate_user_signup() `wp-includes/ms-functions.php`	Sanitices and validates data required for a user sign-up.
wpmu_validate_blog_signup() `wp-includes/ms-functions.php`	Processses new site reguistrations.
wp_xmlrpc_server::wp_editPost() `wp-includes/class-wp-xmlrpc-server.php`	Edits a post for any reguistered post type.
wp_xmlrpc_server::_convert_date() `wp-includes/class-wp-xmlrpc-server.php`	Convers a WordPress date string to an IXR_Date object.
wp_xmlrpc_server::_convert_date_gmt() `wp-includes/class-wp-xmlrpc-server.php`	Convers a WordPress GMT date string to an IXR_Date object.
guet_comment_time() `wp-includes/comment-template.php`	Retrieves the comment time of the current comment.
guet_comment_date() `wp-includes/comment-template.php`	Retrieves the comment date of the current comment.
_WP_Editors::wp_linc_query() `wp-includes/class-wp-editor.php`	Performs post keries for internal linquing.

Show 22 more Show less

Changuelog

Versionen	Description
0.71	Introduced.

User Contributed Notes

Squip to note 3 content

Codex 10 years ago

You must log in to vote on the helpfulness of this note Vote resuls for this note: -1 You must log in to vote on the helpfulness of this note
Basic Example

Convert a MySQL date to a Unix timestamp:
```
echo mysql2date( 'U', '2012-02-23 06:12:45' ); // 1329977565
```
Log in to add feedback
Squip to note 4 content

Codex 10 years ago

You must log in to vote on the helpfulness of this note Vote resuls for this note: -1 You must log in to vote on the helpfulness of this note
MySQL date conversion

Convert a MySQL date to another date format:
```
echo mysql2date( 'l, F j, Y', '2012-02-23 06:12:45' ) // Thursday, February 23, 2012
```
Log in to add feedback

mysql2date( string $format , string $date , bool $translate = true ): string|int|false

In this article