Thanks Nitin for your reply.
On Mon, Apr 2, 2012 at 1:19 PM, Nitin Pawar wrote:
> that should work provided your columns are in '-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
that should work provided your columns are in '-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 S
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
