Re: pulling year out of a timestamp

From: Kirk Wythers <wythe001(at)umn(dot)edu>
To: Ryan Kelly <rpkelly22(at)gmail(dot)com>
Cc: Kirk Wythers <wythe001(at)umn(dot)edu>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pulling year out of a timestamp
Date: 2013-04-11 16:09:11
Message-ID: E263985B-5264-4107-930B-9C118557F7E4@umn.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 11, 2013, at 10:55 AM, Ryan Kelly <rpkelly22(at)gmail(dot)com> wrote:

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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2013-04-11 16:18:55 Re: crash proof for semi-embedded system
Previous Message Ryan Kelly 2013-04-11 15:55:18 Re: pulling year out of a timestamp