Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

docmd.close 2585, WWWXXXAPC, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC., XXXCNZZZ

Links

XODOX
Impressum

#1: Extracting the year

Posted on 2006-03-05 08:59:16 by none

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

select myfield from mytable where year(myfield)=2006

Regards R. Stormo

Report this message

#2: Re: Extracting the year

Posted on 2006-06-01 01:33:11 by 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

Report this message