PHP , formatting a TIMESTAMP retrieved from a mySQL db.

[Al Neri]

i have $date pulled from a timestamp in MYSQL, how do i format it to show for example "9/16/2006 10:15 PM"

 

[imported_LoKe]

date()

 

[igowerf]

You might be able to use strtotime to convert $date into a Unix timestamp, which you can easily format using date().

Otherwise, you can use preg_match or substr to break up the MySQL timestamp into year, month, day, hour, minute and use mktime() to convert all of those values into a Unix timestamp.

date($format,strtotime($date));

date($format,mktime(.....));

 

[Al Neri]

THANK YOU IGOWERF!

 

[Al Neri]

how do I subtract 5 from the hour (i believe its in GMT)

i think timestamp is in GMT?

 

[Al Neri]

i took the unformatted datestamp and subtracted 50000 and it worked, will that always work?

 

[imported_LoKe]

Originally posted by: Don Rodriguez
i took the unformatted datestamp and subtracted 50000 and it worked, will that always work?

EDIT: igowerf has it covered. =D

 

[igowerf]

To remove 5 hours, just subtract 5*3600 from the Unix timestamp.

 

[statik213]

Originally posted by: igowerf
To remove 5 hours, just subtract 5*3600 from the Unix timestamp.

Sure, you also can use the MySQL DATE_ADD/DATE_SUB functions. see here:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

[oog]

yeah, i wouldn't subtract 5*3600 since it doesn't account for the leap day properly.