Re: [GENERAL] pulling year out of a timestamp

[Kirk Wythers]

On Apr 11, 2013, at 10:55 AM, Ryan Kelly <rpkell...@gmail.com> wrote:

> You want date_part, not date_trunc.
> 
> -Ryan

Thanks Ryan. It looks like " EXTRACT(YEAR FROM table2.time2)" works as well.