PHP – Convert from MySQL datetime to another format with PHP

Date is important aspect in developing applications such as storing user registration date time ,last login time, date of birth etc.

Mysql has standard format that is YYYY-mm-dd and but we want that to be in regional or in some other format.

using strtotime and date function printing only date

[pastacode lang=”php” manual=”%3C%3Fphp%0A%20%0A%24mysqlDateTime%20%3D%20’2016-10-17%2021%3A46%3A59’%3B%0Aecho%20date(%22m%2Fd%2FY%22%2C%20strtotime(%24mysqlDateTime))%3B%0Aecho%20%22%3Cbr%3E%22%3B%0A%20%0A%3F%3E%0A” message=”Php Code” highlight=”” provider=”manual”/]

using strtotime and date function printing in the form of timestamp

[pastacode lang=”php” manual=”%3C%3Fphp%0A%0A%24old_date%20%3D%20date(‘l%2C%20F%20d%20y%20h%3Ai%3As’)%3B%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2F%2F%20returns%20Saturday%2C%20January%2030%2010%2002%3A06%3A34%0A%24old_date_timestamp%20%3D%20strtotime(%24old_date)%3B%0A%24new_date%20%3D%20date(‘Y-m-d%20H%3Ai%3As’%2C%20%24old_date_timestamp)%3B%0Aecho%20%24new_date%3B%0Aecho%20%22%3Cbr%3E%22%3B%0A%0A%3F%3E%0A” message=”Php Code” highlight=”” provider=”manual”/] [ad type=”banner”]

strtotime and date printing only date in text format

[pastacode lang=”php” manual=”%3C%3Fphp%0A%0A%24mysqlDateTime%20%3D%20’2016-10-17%2021%3A46%3A59’%3B%0A%24date%20%3D%20strtotime(%24mysqlDateTime)%3B%0Aecho%20date(%22j%20F%20Y%22%2C%20%24date)%3B%20%2F%2Foutput%20will%20be%2010%20July%202013%0A%0A%3F%3E%0A” message=”Php Code” highlight=”” provider=”manual”/]

Using DateTime object in php and format function

[pastacode lang=”php” manual=”%3C%3Fphp%0A%0A%24old_date%20%3D%20date(‘l%2C%20F%20d%20y%20h%3Ai%3As’)%3B%0A%24date%20%3D%20new%20DateTime(%24old_date)%3B%0Aecho%20%24date-%3Eformat(‘Y-m-d%20H%3Ai%3As’)%3B%0A%0A%3F%3E%0A” message=”Php Code” highlight=”” provider=”manual”/]

Using date_create and date_format format function

[pastacode lang=”php” manual=”%3C%3Fphp%0A%0A%24old_date%20%3D%20date(‘l%2C%20F%20d%20y%20h%3Ai%3As’)%3B%0A%24date%20%3D%20date_create(%24old_date)%3B%0Aecho%20date_format(%24date%2C%20’Y-m-d%20H%3Ai%3As’)%3B%0Aecho%20%22%3Cbr%3E%22%3B%0A” message=”Php Code” highlight=”” provider=”manual”/] [ad type=”banner”]