Thread: select users as per their years completion date current year

From

Arup Rakshit

Date:

30 June 2014, 16:06:02

Suppose I have users table. I have a joining_date. Now I only want those users who completed 5 years, 10 years, and in which date they completed.

Example:

Out of all users, suppose below users only -

Foo_1 on 24/1/2014 completed 10 years

Foo_2 on 2/2/2014 completed 10 years

Foo_3 on 14/3/2014 completed 15 years

Foo_4 on 21/3/2014 completed 5 years

They should come in the output

Regards,
Arup Rakshit