Honest, I am not really a newbie, but I don't see any postgresql
function to do this in the documentation. I want to do something like
CREATE TABLE mydate(fu DATE);
INSERT INTO mydate VALUES ('2000-01-01');
SELECT EXTRACT(YEAR FROM DATE fu) FROM mydate;
and get 2000.
But I get a syntax error for the EXTRACT statement when I do this.
SELECT EXTRACT(YEAR FROM DATE '2000-01-01') works just fine. But how do
I get a postgres DATE from a column in a table into EXTRACT as the last
This can't be all that hard!
pgsql-novice by date
|Next:||From: Stephan Szabo||Date: 2009-10-24 00:06:24|
|Subject: Re: How do you get the year from a postgresql DATE?|
|Previous:||From: richard terry||Date: 2009-10-23 22:28:44|
|Subject: Re: creating view - conditional testing in construct|