MySQL Querying Unix Timestamps

Question

I have a table that stores the date/time as a Unix timestamp. Is it possible to query the table and pick out all the entries that are a Monday without having to query all the rows and process them outside of MySQL?

Thanks!

Yes is the answer you are looking for. RTM for the functions DAYOFWEEK() and also FROM_UNIXTIME() — RiggsFolly
– RiggsFolly, Commented Mar 31, 2016 at 15:02

gr1zzly be4r · Accepted Answer · 2016-03-31 15:36:22Z

1

SELECT * FROM your_table WHERE DAYOFWEEK(FROM_UNIXTIME(your_unix_timestamp_column)) = 2

answered Mar 31, 2016 at 15:36

gr1zzly be4r

2,1421 gold badge19 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

MySQL Querying Unix Timestamps

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related