Re: Retrieve month from date

am  Fri, dem 20.04.2007, um 10:30:16 -0700 mailte RPK folgendes:
> 
> What this query will return:
> 
> Select  Extract(Month from 4/20/2007) from dual;
> 
> I suspect "dual" is not for PGSQL but Oracle. But I need to run the above
> query. What is the replacement of "dual" in PGSQL.

Simply "select extract(month from current_date);"

> 
> 
> Bart Degryse wrote:

please no silly fullquote below your text.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net