案外いい感じの関数がなかったのと、業務で書く必要があったので。
DATE_DIFF(CURRENT_DATE(),birthday,YEAR) +
(CASE WHEN
EXTRACT(DAYOFYEAR FROM birthday) > EXTRACT(DAYOFYEAR FROM CURRENT_DATE())
THEN -1 ELSE 0 END) ;;
※birthdayはカラム名
More than 5 years have passed since last update.
Bigqueryで誕生日から年齢を算出する
Last updated at Posted at 2019-08-22
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme