How to compare a date with UNIX timestamp value in php?

Question

I'm having a table(in MySQL) in which all dates are stored in the form of UNIX timestamp values. Now what I want to achieve is fetch up only those records from the table whose date will be today's date. How should I achieve this? Is any one have any magic for it? Please help me out to resolve this issue. Thanks in advance.

please check stackoverflow.com/questions/9251561/…

Andron
– Andron

2013-07-08 08:30:27 +00:00
Commented Jul 8, 2013 at 8:30 — Andron
– Andron, Commented Jul 8, 2013 at 8:30

xiaolee · Accepted Answer · 2013-07-08 08:50:32Z

1

you can get it like this.

eg.

ctime BETWEEN UNIX_TIMESTAMP(CURDATE()) and UNIX_TIMESTAMP(DATE_ADD(CURDATE(),INTERVAL 1 day))

answered Jul 8, 2013 at 8:50

xiaolee

261 bronze badge

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

Comments

mirkobrankovic · Accepted Answer · 2013-07-08 08:34:30Z

0

DATE_FORMAT(FROM_UNIXTIME('date_before_format'), '%e %b %Y') AS 'date_formatted'

answered Jul 8, 2013 at 8:34

mirkobrankovic

2,3471 gold badge22 silver badges24 bronze badges

Collectives™ on Stack Overflow

How to compare a date with UNIX timestamp value in php?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related