MysQL Get Time via Query

Question

The time in row 'Signup' is stored like this: "1427538785" So I am not able to use this method: WHERE DATE(Signup) = DATE(NOW())

But need to get the query where time of signup is today..

Any Idea how to solve this?

FROM_UNIXTIME() converts to a datetime

Saty
– Saty

2015-03-28 10:14:16 +00:00
Commented Mar 28, 2015 at 10:14 — Saty
– Saty, Commented Mar 28, 2015 at 10:14

Abhik Chakraborty · Accepted Answer · 2015-03-28 10:12:58Z

1

You need from_unixtime

mysql> select from_unixtime('1427538785','%Y-%m-%d');
+----------------------------------------+
| from_unixtime('1427538785','%Y-%m-%d') |
+----------------------------------------+
| 2015-03-28                             |
+----------------------------------------+
1 row in set (0.00 sec)

So the query will be

WHERE from_unixtime(Signup,'%Y-%m-%d') = curdate();

answered Mar 28, 2015 at 10:12

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

Comments

juergen d · Accepted Answer · 2015-03-28 10:12:15Z

0

WHERE DATE(FROM_UNIXTIME(Signup)) = curdate()

answered Mar 28, 2015 at 10:12

juergen d

205k40 gold badges305 silver badges377 bronze badges

3 Comments

Blackhole Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.

juergen d Over a year ago

It answers the question with the solution.

Vladimir F Героям слава Over a year ago

As a very high rep user please don't fill up the low quality review queue with a code dump only answer. We have enough of them from the newcomers. This answer was flagged as low-quality because of its length and content.

Collectives™ on Stack Overflow

MysQL Get Time via Query

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related