Convert Mysql date to Google sitemap date format PHP

php Share on :

Convert your MySql format date to the date that can be readable to Google sitemaps API using PHP

<?php
    //MYSQL DATE FORMAT
    $updated_date = '2021-01-28 11:52:19';

    $new_datetime = new DateTime($updated_date);
    $final_date = $new_datetime->format('Y-m-d\TH:i:sP');

    echo $final_date; //2021-01-28T11:52:19+01:00
?>

In the code snippet, we have stored the date to our MySql database and when we try to create a sitemap, we need to change the format of the date so that the google sitemap API could red it unless it will throw the error. We are using the DateTime function of PHP for that and then its 'format' method to get the desired format date.

Search Index Data (The code snippet can also be found with below search text)

Google Sitemap date PHP Mysql

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer