Skip to content

Instantly share code, notes, and snippets.

@alancoleman

alancoleman/using _DATE_SUB_filter_dates.sql

Created December 9, 2013 11:46
Show Gist options
  • Save alancoleman/7871079 to your computer and use it in GitHub Desktop.
Save alancoleman/7871079 to your computer and use it in GitHub Desktop.
Download ZIP
Using DATE_SUB to filter all records within the last eight months
Raw
using _DATE_SUB_filter_dates.sql
WHERE date >= DATE_SUB(NOW(), INTERVAL 8 MONTH)
-- Returns everything within the last 8 months
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment