Skip to content

Instantly share code, notes, and snippets.

@AssafMashiah
Created March 1, 2016 19:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AssafMashiah/094566032e2983b08b05 to your computer and use it in GitHub Desktop.
Save AssafMashiah/094566032e2983b08b05 to your computer and use it in GitHub Desktop.
Date mysql fun
DATE_FORMAT(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH), '%Y-%m-01 05:00:00') AND DATE_FORMAT(NOW(), '%Y-%m-01 05:00:00')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment