Jump to content

Selecting only rows with a date within last 8 months


Recommended Posts

I want to perform a SELECT on a table and only get rows that have a date of less than 8 months ago. The column that contains the date is in the timestamp format "2007-11-29 12:00:00". How would I do this? Here's the sudo-code:

SELECT *FROM exampleWHERE date > 8 months ago

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...