Calculate the Age from the DOB

Question

I am using HiveQL and I need to calculate the age just by using the Date of birth column but the issue is GetDate doesn’t work however Current_Date() does. The example I am trying is

datediff(yy,Dateofbirthcol,current_date()) As Age.

The DOB column looks like 1988-12-14.

Maybe you should add your entire request, this will help us – Sparw Apr 28 '20 at 12:21 — Sparw, Apr 28 '20 at 12:21

score 2 · Answer 1 · answered Apr 28 '20 at 02:57

2

Try one of the following option.

floor(datediff(to_date(from_unixtime(unix_timestamp())), Dateofbirthcol) / 365.25)
datediff(now(), Dateofbirthcol) / 365.25

answered Apr 28 '20 at 02:57

zealous

7,336
4
16
36

leftjoin · Answer 2 · 2020-04-29T05:14:59.520

0

Do not use unix_timestamp() because it is non-deterministic. Use current_date:

 datediff(current_date, Dateofbirthcol) / 365.25

edited Apr 29 '20 at 05:14

answered Apr 28 '20 at 08:39

leftjoin

36,950
8
57
116

3

Please don't post only code as an answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually of higher quality, and are more likely to attract upvotes. – today Apr 28 '20 at 23:18
Thank you every one for all your help and I am sorry I will not be doing that next time – Nina Apr 29 '20 at 03:30

Calculate the Age from the DOB

2 Answers2