Thanks for your response, I appreciate it.
Apparently I'm a moron on 2 counts.. :-)
1. I'm actually using WinSQL to query the database, not MySQL as I incorrectly noted in my previous post (not sure if that makes a diff)
2. I tried your suggestion and still can't get it to work (perhaps cuz of #1 above???). I get this message:
Error: Incorrect syntax near the keyword 'CURRENT_DATE'. (State:37000, Native...
User Profile
Collapse
-
SQL to automatically select only current date's rows
Hello...
I have a table with a number of fields along with a time stamp column... I am wondering how I can query for only rows inserted on the current date other than manually entering the date parameter... An example below:
Let's say I had a table like this:
OFF_ID OFFER RESULT ENTRY_TS
2719 MAGAZINE NOT INTERESTED 2006-09-27 16:11:06.678
2720 CAR ACCEPT 2006-09-27 16:15:02.231
...
No activity results to display
Show More
Leave a comment: