How to get date from MySQL timestamp using PHP

Question

My timestamp in MySQL is 1571591400 and I want to get the date from this timestamp. I have tried a number of things but but nothing has worked.

"SELECT * FROM fixture_fixture WHERE from_unixtime(event_timestamp, '%Y-%m-%d') = '$date'";

Does this answer your question? Convert Unix timestamp into human readable date using MySQL — Dharman
– Dharman ♦, Commented Dec 4, 2019 at 10:16

lczapski · Accepted Answer · 2019-12-04 08:08:04Z

1

Below may help.

SELECT FROM_UNIXTIME(1571591400, '%D %M %Y');
o/p - '20th October 2019'
SELECT FROM_UNIXTIME(1571591400) As 'String';
o/p - '2019-10-20 21:10:00'

lczapski

4,1603 gold badges18 silver badges35 bronze badges

answered Dec 4, 2019 at 6:56

bijita banerjee

111 bronze badge

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

Comments

Vikas Verma · Accepted Answer · 2019-12-04 06:53:36Z

0

If you want date from you timestamp then you should trythis

  SELECT DATE_FORMAT(FROM_UNIXTIME(column_name), '%e %b %Y') AS 'date_formatted' FROM `fixture_fixture `

answered Dec 4, 2019 at 6:53

Vikas Verma

1491 silver badge11 bronze badges