Re: [GENERAL] Extract between year *and* month

2006-11-24 Thread Syl
Russell Smith wrote: > One wrote: > > Hi - I'd like to return search results based on a date range that is > > selected by the user : > > > > > >1995 > > > > > >2006 > > > > My SQL is : > > > > select * > > from tablename > > where title like ('%nith%') > >and recall

Re: [GENERAL] Extract between year *and* month

2006-12-01 Thread Syl
Alban Hertroys wrote: > Syl wrote: > >> Try > >> > >> select * > >> from tablename > >> where title like ('%nith%') > >>and date_trunc('month',recall_date::timestamp) >= > >> date_trunc(&