select users as per their years completion date current year

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема select users as per their years completion date current year
Дата
Msg-id 1404133553.69103.YahooMailNeo@web193906.mail.sg3.yahoo.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Very high latency, low bandwidth replication
Следующее
От: Emre Hasegeli
Дата:
Сообщение: Re: Examples of projects that use Postgres "as API server"