Search Postgresql Archives

Re: pulling year out of a timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Ryan Kelly <rpkelly22@xxxxxxxxx>
Subject: Re: pulling year out of a timestamp
From: Kirk Wythers <wythe001@xxxxxxx>
Date: Thu, 11 Apr 2013 11:09:11 -0500
Cc: Kirk Wythers <wythe001@xxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <20130411155518.GB13565@llserver.lakeliving.com>

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

You want date_part, not date_trunc.

-Ryan

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- pulling year out of a timestamp
  - From: Kirk Wythers
- Re: pulling year out of a timestamp
  - From: Ryan Kelly

Prev by Date: Re: pulling year out of a timestamp
Next by Date: Re: crash proof for semi-embedded system
Previous by thread: Re: pulling year out of a timestamp
Next by thread: [no subject]
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux