collecting employees who completed 5 and 10 years in the current month

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: collecting employees who completed 5 and 10 years in the current month
Date: 2014-06-30 10:38:53
Message-ID: 1404124733.14889.YahooMailNeo@web193902.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have employee table. Where I have a column joining_date. Now I am looking for a way to get all employee, who completed 5 years, 10 years current month. How to do so ? I am not able to figure this out.
 
Regards,
Arup Rakshit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2014-06-30 11:00:22 Re: collecting employees who completed 5 and 10 years in the current month
Previous Message Oliver 2014-06-30 10:29:57 Re: [pgadmin-support] Best backup strategy for production systems