Help with a simple Query.

[DBookatay]

 

SELECT * FROM Sold WHERE substr(sold_date, 0, 4) = 2010 

 

 

What I am trying to do is select all rows from the database from 2010, from the "sold_date" field.

How is this accomplished with date values? (ex: "2010-08-11", "2009-01-15")

[PFMaBiSmAd]

What you posted should work. However YEAR() would be clearer and probably faster -

 

SELECT * FROM Sold WHERE YEAR(sold_date) = 2010 

[DBookatay]

What you posted should work. However YEAR() would be clearer and probably faster -

 

SELECT * FROM Sold WHERE YEAR(sold_date) = 2010 

 

My code didn't work, yours did though.

Thank you...

[PFMaBiSmAd]

Upon further review, the first position for substr() is 1.

[DBookatay]

Upon further review, the first position for substr() is 1.

 

I'm sorry but I don't understand

[PFMaBiSmAd]

Should work (however as mentioned, the year() function is probably a lot faster) -

SELECT * FROM Sold WHERE substr(sold_date, 1, 4) = 2010