SQL: Query where date is like today

Question

I have a little problem with my SQL Query:

I have this value on my table: 2014-10-23 00:00:00

I have a record like this each 2 minutes every day, and I need to SELECT all the value of today.

Now I made this:

WHERE mytable.data LIKE CURDATE()

and it doesn't work. I tried a lot of things found here on stackoverflow and nothing could help me. Thanks for answer.

possible duplicate of http://stackoverflow.com/questions/113045/how-to-return-the-date-part-only-from-a-sql-server-datetime-datatype — KHeaney, Oct 23 '14 at 14:53
@KHeaney I already tried that, cause i tried a lot of things and I could not found a solution, now I'm gonna try the Tony's solution. — Claudio Ciamarra, Oct 24 '14 at 09:06

Tony · Accepted Answer · 2014-10-23T15:11:24.583

1

You don't say which version of SQL Server you are using, if you have the DATE data type available you can cast the datetime returned by getdate() or CURRENT_TIMESTAMP to strip off the time part.

But then you need a range to find all the matching rows, something like:

SELECT *
FROM mytable
WHERE mytable.data >= CAST(GETDATE() AS date)
  AND mytable.data < CAST(DATEADD(day, 1, GETDATE()) AS date)

SQL Fiddle

edited Oct 23 '14 at 15:11

answered Oct 23 '14 at 15:00

Tony

9,672
3
47
75

Hi Tony, thanks you about your corrections at my question and I'm sorry to didn't say my SQL version, it's 5.1.73. – Claudio Ciamarra Oct 24 '14 at 09:16
I used this form: AND mytable.data >= CAST( NOW( ) AS DATE ) It seems enough about what i need, and it works as well. Thanks you about your support. – Claudio Ciamarra Oct 24 '14 at 09:23

SQL: Query where date is like today

1 Answers1