convert unix time in php

Question

I am trying to convert a unix time stam in php but I am getting errors. I've done lots of research but non works. I keep on getting output 12/31/1969

time stamp from sql = 1396483200

my php is

$q=mysql_query("SELECT * FROM schedule WHERE ID='$id' LIMIT 1");
$q=mysql_fetch_array($q);
$a_sdate=$q['SCHEDULE_DATE'];
$a_sdate=date("m/d/Y", strtotime($a_sdate));

can anyone tell me what I am doing wrong?

xdazz · Accepted Answer · 2014-04-04 02:31:46Z

1

If you already got the unix timestamp from the database, then you don't need to use strtotime:

$a_sdate=date('m/d/Y', $a_sdate);

answered Apr 4, 2014 at 2:31

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

convert unix time in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related