Skip to content

Instantly share code, notes, and snippets.

@kmonsoor

kmonsoor/snippets.sql

Last active February 2, 2018 11:59
Show Gist options
  • Save kmonsoor/a17f1199694c6f374390818e502c42ae to your computer and use it in GitHub Desktop.
Save kmonsoor/a17f1199694c6f374390818e502c42ae to your computer and use it in GitHub Desktop.
Download ZIP
MySQL get current date in PST timezone
Raw
snippets.sql
-- Get current date in PST time-zone
SELECT DATE_ADD(DATE(CONVERT_TZ(current_time(), 'GMT', 'US/Pacific'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment