Need to convert a string(time) in sql to real date in php

Question

I have a table with a time (int 4) where is stored time ex:1506201203

That would be:

year-mo-da-hh-mm
2015-06-20-12-03

I need a php script to get the time and display it correctly ..

A bit of help ?

already has an answer here:http://stackoverflow.com/questions/10040291/converting-a-unix-timestamp-to-formatted-date-string — BigScar, Jun 20 '15 at 11:35

score 0 · Answer 1 · edited Mar 29 '18 at 14:01

0

FROM_UNIXTIME(column_name, '%Y-%m-%d') in your MySQL query.

Or you can just use date function.

date('Y-m-d-h-m', $n['date']).

edited Mar 29 '18 at 14:01

Hamza Zafeer

answered Jun 20 '15 at 11:34

Louay Ali

1 Answers1