CODEWITHSUNDEEP
mysql
Gikkman
Gikkman

Reputation: 762

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?

Upvotes: 1

Views: 313

Answers (1)

Lokesh Kumar Gaurav
Lokesh Kumar Gaurav

Reputation: 726

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'

Upvotes: 1

Related Questions