Skip to content

Instantly share code, notes, and snippets.

@Boztown

Boztown/date.sql

Created March 14, 2012 19:31
Show Gist options
  • Save Boztown/2038871 to your computer and use it in GitHub Desktop.
Save Boztown/2038871 to your computer and use it in GitHub Desktop.
Download ZIP
SQL: Date within 1 month
Raw
date.sql
SELECT * FROM purchases WHERE company_id = 17 AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= created_at;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment