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

Convert given date string into a different format.

Contents

Description Description

$format should be either a PHP date format string, e.g. ‘U’ for a Unix timestamp, or ‘G’ for a Unix timestamp assuming that $date is GMT.

If $translate is true then the given date and format string will be passed to date_i18n() for translation.

Parameters 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 value: true

Top ↑

Return Return

(string|int|bool) Formatted date string or Unix timestamp. False if $date is empty.

Top ↑

Source Source

File: wp-includes/functions.php 

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

	if ( 'G' == $format ) {
		return strtotime( $date . ' +0000' );
	}

	$i = strtotime( $date );

	if ( 'U' == $format ) {
		return $i;
	}

	if ( $translate ) {
		return date_i18n( $format, $i );
	} else {
		return date( $format, $i );
	}
}

Expand full source code Collapse full source code View on Trac

Top ↑

Changelog Changelog

Changelog
Version Description
0.71 Introduced.

Top ↑

Top ↑

Uses Uses

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

Retrieve the date in localized format, based on a sum of Unix timestamp and timezone offset in seconds.

Top ↑

Used By Used By

Used By
Used By Description
wp-includes/class-wp-customize-manager.php: WP_Customize_Manager::save_changeset_post()

Save the post for the loaded changeset.
wp-includes/comment.php: wp_check_comment_flood()

Checks whether comment flooding is occurring.
wp-includes/functions.php: mysql_to_rfc3339()

Parses and formats a MySQL datetime (Y-m-d H:i:s) for ISO8601 (Y-m-d\TH:i:s).
wp-admin/includes/class-wp-posts-list-table.php: WP_Posts_List_Table::column_date()

Handles the post date column output.
wp-admin/includes/class-wp-ms-sites-list-table.php: WP_MS_Sites_List_Table::column_lastupdated()

Handles the lastupdated column output.
wp-admin/includes/class-wp-ms-sites-list-table.php: WP_MS_Sites_List_Table::column_registered()

Handles the registered column output.
wp-admin/includes/class-wp-ms-users-list-table.php: WP_MS_Users_List_Table::column_registered()

Handles the registered date column output.
wp-admin/includes/class-wp-media-list-table.php: WP_Media_List_Table::column_date()

Handles the date column output.
wp-includes/class-wp-query.php: WP_Query::setup_postdata()

Set up global post data.
wp-admin/includes/export.php: export_wp()

Generates the WXR export file for download.
wp-admin/includes/template.php: get_inline_data()

Adds hidden fields with the data for use in the inline editor for posts and pages.
wp-admin/includes/template.php: touch_time()

Print out HTML form date elements for editing post or comment publish date.
wp-admin/includes/media.php: get_media_item()

Retrieve HTML form for modifying the image attachment.
wp-admin/includes/ajax-actions.php: wp_ajax_wp_fullscreen_save_post()

Ajax handler for saving posts from the fullscreen editor.
wp-admin/includes/ajax-actions.php: wp_ajax_find_posts()

Ajax handler for querying posts for the Find Posts modal.
wp-includes/general-template.php: get_post_time()

Retrieve the time at which the post was written.
wp-includes/general-template.php: get_post_modified_time()

Retrieve the time at which the post was last modified.
wp-includes/general-template.php: the_weekday()

Display the weekday on which the post was written.
wp-includes/general-template.php: the_weekday_date()

Display the weekday on which the post was written.
wp-includes/general-template.php: wp_get_archives()

Display archive links based on type and format.
wp-includes/general-template.php: the_date_xml()

Outputs the date in iso8601 format for xml files.
wp-includes/deprecated.php: get_boundary_post_rel_link()

Get boundary post relational link.
wp-includes/deprecated.php: get_parent_post_rel_link()

Get parent post relational link.
wp-includes/class-wp.php: WP::send_headers()

Sends additional HTTP headers for caching, content type, etc.
wp-includes/link-template.php: get_adjacent_post_link()

Retrieves the adjacent post link.
wp-includes/link-template.php: get_adjacent_post_rel_link()

Retrieves the adjacent post relational link.
wp-includes/class-walker-page.php: Walker_Page::start_el()

Outputs the beginning of the current element in the tree.
wp-includes/media.php: wp_prepare_attachment_for_js()

Prepares an attachment post object for JS, where it is expected to be JSON-encoded and fit into an Attachment model.
wp-includes/post.php: wp_insert_post()

Insert or update a post.
wp-includes/ms-functions.php: wpmu_validate_user_signup()

Sanitize and validate data required for a user sign-up.
wp-includes/ms-functions.php: wpmu_validate_blog_signup()

Processes new site registrations.
wp-includes/class-wp-xmlrpc-server.php: wp_xmlrpc_server::wp_editPost()

Edit a post for any registered post type.
wp-includes/class-wp-xmlrpc-server.php: wp_xmlrpc_server::_convert_date()

Convert a WordPress date string to an IXR_Date object.
wp-includes/class-wp-xmlrpc-server.php: wp_xmlrpc_server::_convert_date_gmt()

Convert a WordPress GMT date string to an IXR_Date object.
wp-includes/comment-template.php: get_comment_time()

Retrieve the comment time of the current comment.
wp-includes/comment-template.php: get_comment_date()

Retrieve the comment date of the current comment.
wp-includes/class-wp-editor.php: _WP_Editors::wp_link_query()

Performs post queries for internal linking.
Show 32 more used by Hide more used by

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.