Getting year of timestamp in PostgreSQL

Question

I have table called TrainingMatrix and it has a column called ExpiryDate. I am trying to write an SQL statement which can show me all records of 2012 as following:

 SELECT * FROM "TrainingMatrix" WHERE "ExpiryDate" - current_date < 0 AND EXTRACT(YEAR FROM TIMESTAMP "ExpiryDate") = 2012;

But this doesn't work, can any one help?

I am using PostgreSQL.

igr · Accepted Answer · 2013-10-19 07:14:46Z

3

No timestamp word when using column:

... AND EXTRACT(YEAR FROM "ExpiryDate") = 2012 ...

answered Oct 19, 2013 at 7:14

igr

3,5091 gold badge22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomasz Myrta · Accepted Answer · 2013-10-19 08:26:38Z

2

If you have index on ExpiryDate column - it's better to avoid using functions and have exact date/timestamp range:

and "ExpiryDate">='2012-01-01' and "ExpiryDate"<'2013-01-01';

answered Oct 19, 2013 at 8:26

Tomasz Myrta

1,1449 silver badges11 bronze badges

Collectives™ on Stack Overflow

Getting year of timestamp in PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related