How to write Hiveql to select a column between current date and 3 years back.
How to write Hiveql to select a column between current date and 2 months back.
I have the following table of students.
id name location dob
1 Aman Pune 2007-06-04
2 Nyasha Nasik 2015-10-22
3 Sumit Delhi 2016-01-02
4 Arjun Noida 1991-03-14
5 Ram Dehradun 1975-12-23
How to write HiveQL to select Birthdays between current date and 3 year back: