so i have a bunch of timestamps saved in my database, and im trying to return the results from a certain week. Say week 5 of this year (first week of feb).
im trying something like this but its not working
SELECT * FROM table where WEEK(timestamp) = ‘5’
am i missing something?
im trying something like this but its not working
would you care to enlighten us further?
Is your column actually called TIMESTAMP? OR do you need to substitute the correct column name?
When you state “not working” that doesn’t give enough details for people to help you.
by not working, i mean its not returning any results.
the column is actually called date so.
SELECT * FROM table where WEEK(date) = ‘5’
r937
March 17, 2011, 7:01pm
4
if that query is not returning any rows, that means there aren’t any rows which satisfy that partucular WHERE clause