wpseek.com
A WordPress-centric search engine for devs and theme authors
mysql2date › WordPress Function
Since0.71
Deprecatedn/a
› mysql2date ( $format, $date, $translate = true )
Parameters: (3) |
|
Returns: |
|
Defined at: |
|
Codex: |
Converts given MySQL date string into a different format.
-$format
should be a PHP date format string.
- 'U' and 'G' formats will return an integer 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.Source
function mysql2date( $format, $date, $translate = true ) {
if ( empty( $date ) ) {
return false;
}
$timezone = wp_timezone();
$datetime = date_create( $date, $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(), $timezone );
}
return $datetime->format( $format );
}