On Apr 11, 2013, at 10:55 AM, Ryan Kelly wrote:
> You want date_part, not date_trunc.
>
> -Ryan
Thanks Ryan. It looks like " EXTRACT(YEAR FROM table2.time2)" works as well.
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 timestamp in table 2.
>
> Something like this:
>
> table1.year = table2.timestamp
> where timestamp has th
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 timestamp in 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
