Gikkman Gikkman - 1 year ago 98
MySQL Question

MySQL - DateTime from certain point in time till end of that day

I've been trying to create a query that gathers all rows from a certain datetime, till the end of that specific day. Is this possible in some neat way?

Answer Source

Try this replace date base on your requirement.

SELECT users.* FROM users WHERE date(created_at) = date('2016-10-04 10:12:10') and created_at >='2016-10-04 10:12:10'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download