I changed TIMESTAMP to read dbTime because I thought that maybe using TIMESTAMP as a variable name wouldn't be a good idea. Regardless, now I have no error, but whether by inequality is less than or greater than, I get no rows back.

My goal is to get all records with dbTimes that are earlier than 3 days in the past. Any additional thoughts or hints would be appreciated.

-Eric

r937
—
2011-05-25T18:37:47Z —
#7

kreut said:

Any additional thoughts or hints would be appreciated.

did you try it the way i suggested?

WHERE dbtime < CURRENT_DATE - INTERVAL 3 DAY

kreut
—
2011-05-25T18:45:30Z —
#8

r937:

Thank you for the solution and your patient response: due to a lag in receiving your messages, it only seemed as though I wasn't taking your advice right off the bat.