Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF

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