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'";

Already answered https://stackoverflow.com/questions/6267564/convert-unix-timestamp-into-human-readable-date-using-mysql — Jahan zeb, Dec 04 '19 at 09:49
Does this answer your question? [Convert Unix timestamp into human readable date using MySQL](https://stackoverflow.com/questions/6267564/convert-unix-timestamp-into-human-readable-date-using-mysql) — Dharman, Dec 04 '19 at 10:16

score 1 · Answer 1 · edited Dec 04 '19 at 08:08

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'

edited Dec 04 '19 at 08:08

lczapski

answered Dec 04 '19 at 06:56

bijita banerjee

score 0 · Answer 2 · answered Dec 04 '19 at 06:53

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 04 '19 at 06:53

Vikas Verma

2 Answers2