Skip to content

Instantly share code, notes, and snippets.

@hesoyamcode

hesoyamcode/TZ Convert

Created September 3, 2018 14:02
Show Gist options
  • Save hesoyamcode/b7b4e9a82342b52860b14dd3391d038b to your computer and use it in GitHub Desktop.
Save hesoyamcode/b7b4e9a82342b52860b14dd3391d038b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TZ Convert
SELECT CONVERT_TZ(NOW(),'-07:00', city.TimeZone) AS Time, city.Name
FROM city, country
WHERE country.Name='USA' and city.CountryId= country.CountryId;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment