janbenetka/leading_zero.sql

Created August 23, 2020 17:31

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/janbenetka/298b552fcbe89205c28012e5c142e3bf.js"></script>
Save janbenetka/298b552fcbe89205c28012e5c142e3bf to your computer and use it in GitHub Desktop.

Download ZIP

[Add leading zeros in BigQuery] #leading_zero #bigquery

Raw

leading_zero.sql

	SUBSTR(FORMAT("00%d", state_fips ), -2) as state_fips,
	SUBSTR(FORMAT("00000%d", fips ), -5) as fips,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment