how to convert time(mktime) to date(mm/dd/yyyy) in php?

php mysql date mktime
kester martinez picture kester martinez · Jun 10, 2011 · Viewed 15.6k times · Source

ok i have a birthday form that will save as time using mktime, so when it is saved in mysql, it will show something like 634608000.. how can i convert it to mm/dd/yyyy format so that when it is displayed in html it will be readable..?

Answer

datasage picture datasage · Jun 10, 2011

All you need is this:

 date('m/d/Y',$time)

Related questions

PHP mysql insert date format

Im using jQuery datepicker the format of the datepicker is this 08/25/2012 i have errors when inserting to my database it insert only 0000-00-00 00 00 00 my codes is <?php $id = $_POST['id']; $name = $_POST['name']; $date = $_POST['date']; $sql = mysql_…

Read More
adding 1 day to a DATETIME format value

In certain situations I want to add 1 day to the value of my DATETIME formatted variable: $start_date = date('Y-m-d H:i:s', strtotime("{$_GET['start_hours']}:{$_GET['start_minutes']} {$_GET['start_ampm']}")); What is the best way to do …

Read More
How to display a date as iso 8601 format with PHP

I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong. 17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 …

Read More