that should work provided your columns are in 'yyyy-mm-dd' format and you are ok to leave out leap years :)
also its a good idea to have all the mathematical operations in a bracketed manner so u can have it like where round(datediff(date,dob)/365) >=18 On Mon, Apr 2, 2012 at 1:04 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > Hello all, > I am trying to check age in hive. > select * from tbl_name where datediff(date,dob)/365 >= 18; > > Is it right to check date condition in hive? > Or do I need to do something else. > Pls suggest me as soon as possible > > > -- > Thanks and Regards, > Bhavesh Shah > > -- Nitin Pawar
