WordPress at a glance

mysql2date() WP 1.0

Convert given date string into a different format.

$format should be a PHP date format string. 'U' and 'G' formats will return a sum of timestamp with timezone 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 given date and format string will be passed to wp_date() for translation.

Works based on: wp_date()
✈ 1 time = 0.00018s = fast | 50000 times = 4.42s = fast

No Hooks.

Return

String/Int/false. Formatted date string or sum of Unix timestamp and timezone offset. False on failure.

Usage

mysql2date( $format, $date, $translate );
$format(string) (required)
Format of the date to return.
$date(string) (required)
Date string to convert.
$translate(true/false)
Whether the return date should be translated.
Default: true

Changelog

Since 0.71 Introduced.

Code of mysql2date: wp-includes/functions.php WP 5.4.2

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

	$datetime = date_create( $date, wp_timezone() );

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

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

	if ( $translate ) {
		return wp_date( $format, $datetime->getTimestamp() );
	}

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

Related Functions

From tag: date time

No comments
        Log In . Register