Right you are David re my first query. That'll be more appropriate if you
want to establish if they're in their 5th year, or 10th year.
On Mon, Jun 30, 2014 at 6:08 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Rebecca Clarke-2 wrote
> > create view vw_employee as
> >select *
Rebecca Clarke-2 wrote
> create view vw_employee as
>select * from employees
>where ((age(joining_date::date) like '5 years%') or
> (age(joining_date::date) like '10 years%') )
This does not give the correct answer to the poster's question - the LIKE
with a trailing "%" will pick up non-r