kmonsoor/snippets.sql

Last active February 2, 2018 11:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kmonsoor/a17f1199694c6f374390818e502c42ae.js"></script>
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