mysql date to php

Question

I have a date field in mysql that contains numbers like 2455419. Any idea what format this is and how to convert to php/human eadable form?

Shubham · Accepted Answer · 2010-08-12 04:04:46Z

2

Seems to be Unix Timestamp. You can convert it to human readable form by using date() function of PHP.

answered Aug 12, 2010 at 4:04

Shubham

22.5k18 gold badges71 silver badges91 bronze badges

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

1 Comment

Or you could use strftime. you could also convert it with a conversion function in your actual query with similar functions in mysql.