Postgres Pro
Downloads
Home   >   mailing lists

select users as per their years completion date current year - Mailing list pgsql-general

From Arup Rakshit
Subject select users as per their years completion date current year
Date
Msg-id 1404133553.69103.YahooMailNeo@web193906.mail.sg3.yahoo.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Very high latency, low bandwidth replication
Next
From: Emre Hasegeli
Date:
Subject: Re: Examples of projects that use Postgres "as API server"