Skip to content

Instantly share code, notes, and snippets.

@mbforr

mbforr/zip_cast.sql

Created July 6, 2021 19:44
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mbforr/3cdb723cb097c5f750adc2220320ed33 to your computer and use it in GitHub Desktop.
Save mbforr/3cdb723cb097c5f750adc2220320ed33 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
zip_cast.sql
SELECT
# the CAST() function allows you to change data types
zip_code, cast(zip_code as int64) as zip_numeric
FROM `bigquery-public-data.geo_us_boundaries.zip_codes`
order by zip_code asc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment