Postgres Pro
Downloads
Home   >   mailing lists

Re: pulling year out of a timestamp - Mailing list pgsql-general

From Kirk Wythers
Subject Re: pulling year out of a timestamp
Date
Msg-id E263985B-5264-4107-930B-9C118557F7E4@umn.edu
Whole thread Raw
In response to Re: pulling year out of a timestamp  (Ryan Kelly <rpkelly22@gmail.com>)
List pgsql-general
Tree view

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

You want date_part, not date_trunc.

-Ryan

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

pgsql-general by date:

Previous
From: Ryan Kelly
Date:
Subject: Re: pulling year out of a timestamp
Next
From: Steve Atkins
Date:
Subject: Re: crash proof for semi-embedded system