{"id":1890,"date":"2023-02-08T11:00:53","date_gmt":"2023-02-08T02:00:53","guid":{"rendered":"https:\/\/www.kwonline.org\/memo2\/?p=1890"},"modified":"2023-02-08T11:00:53","modified_gmt":"2023-02-08T02:00:53","slug":"sql-to-calculate-age-from-date-of-birth","status":"publish","type":"post","link":"https:\/\/www.kwonline.org\/memo2\/2023\/02\/08\/sql-to-calculate-age-from-date-of-birth\/","title":{"rendered":"SQL \u3067\u751f\u5e74\u6708\u65e5\u304b\u3089\u5e74\u9f62\u3092\u7b97\u51fa\u3059\u308b"},"content":{"rendered":"<p>Snowflake \u3067\u4f5c\u3063\u305f DWH \u4e0a\u3067\u751f\u5e74\u6708\u65e5\u304b\u3089\u5e74\u9f62\u3092\u7b97\u51fa\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<p>\u4eca\u65e5\u306e\u65e5\u4ed8YYYYMMDD \u304b\u3089 \u8a95\u751f\u65e5YYYYMMDD \u3092\u6570\u5b57\u3068\u3057\u3066\u30de\u30a4\u30ca\u30b9\u3057\u3066\u300110000\u3067\u5272\u3063\u3066\u7aef\u6570\u3092\u5207\u308a\u6368\u3066\u308c\u3070OK<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nselect\r\n    floor((to_varchar(current_date, 'YYYYMMDD')::number \r\n        - to_varchar(d.date_of_birth, 'YYYYMMDD')::number) \/ 10000) as age\r\nfrom\r\n    dim_person as d;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Snowflake \u3067\u4f5c\u3063\u305f DWH \u4e0a\u3067\u751f\u5e74\u6708\u65e5\u304b\u3089\u5e74\u9f62\u3092\u7b97\u51fa\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002 \u4eca\u65e5\u306e\u65e5\u4ed8YYYYMMDD \u304b\u3089 \u8a95\u751f\u65e5YYYYMMDD \u3092\u6570\u5b57\u3068\u3057\u3066\u30de\u30a4\u30ca\u30b9\u3057\u3066\u300110000\u3067\u5272\u3063\u3066\u7aef\u6570\u3092\u5207\u308a\u6368\u3066\u308c\u3070OK s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,20],"tags":[],"class_list":["post-1890","post","type-post","status-publish","format-standard","hentry","category-snowflakedb","category-sql"],"_links":{"self":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/comments?post=1890"}],"version-history":[{"count":2,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1890\/revisions"}],"predecessor-version":[{"id":1892,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1890\/revisions\/1892"}],"wp:attachment":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/media?parent=1890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/categories?post=1890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/tags?post=1890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}