vkhazin/bigquery-timestamp-nginx.sql

Created September 1, 2022 19:19

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/vkhazin/927c90a60ab9747ffcce9ea5f2ec2431.js"></script>
Save vkhazin/927c90a60ab9747ffcce9ea5f2ec2431 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

bigquery-timestamp-nginx.sql

cast(UNIX_SECONDS(PARSE_TIMESTAMP("%d/%b/%Y:%H:%M:%S %z", time)) as string) as time

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