Gikkman Gikkman - 1 month ago 10
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

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'
Comments