Re: pulling year out of a timestamp

On Thu, Apr 04/11/13, 2013 at 10:50:53AM -0500, Kirk Wythers wrote:
> I am trying to perform a join between two tables where I need to join "year" in table 1 with the year component of a
timestampin table 2. 
>
> Something like this:
>
> table1.year = table2.timestamp
> where timestamp has the format:  "2009-01-01 00:00:00"
>
> I've tried
>
> date_trunc('year', table2.timestamp) = table1.year

You want date_part, not date_trunc.

-Ryan