Extracting the year

Extracting the year

am 05.03.2006 08:59:16 von none

How to select records from a choosen year?
Something like this

select myfield from mytable where year(myfield)=2006

Regards R. Stormo

Re: Extracting the year

am 01.06.2006 01:33:11 von Bent Stigsen

none wrote:
> How to select records from a choosen year?
> Something like this
>
> select myfield from mytable where year(myfield)=2006

It's in the documentation:
http://www.postgresql.org/docs/

-> SQL Language
-> Functions and Operators
-> Date/Time Functions and Operators


/Bent