BigQuery and query SQL

Question

I have a dataset with name and date of birth of some people, and I want to calculate their age! I helped to form the query (for BigQuery) to obtain this result? thanks

Could you show us what have you tried so far?

Balazs Gunics
– Balazs Gunics

2013-06-10 14:17:19 +00:00
Commented Jun 10, 2013 at 14:17 — Balazs Gunics
– Balazs Gunics, Commented Jun 10, 2013 at 14:17

Felipe Hoffa · Accepted Answer · 2013-06-10 21:02:47Z

1

That should be easy for BigQuery, a lot depends on how you are storing the date of birth.

Let's say it's a string, on the form '2005-10-01'. One way to get ages is:

SELECT INTEGER(
    (NOW() - (TIMESTAMP(CONCAT(birthdate, ' 00:00:00'))))
    / 24/3600/365/1000/1000)
FROM users

answered Jun 10, 2013 at 21:02

Felipe Hoffa

59.8k23 gold badges185 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gilberto Torrezan Over a year ago

How does this deal with leap years?

Collectives™ on Stack Overflow

BigQuery and query SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related