I have one date field in the format "1/31/2005" that is actually a url parameter value and a field in a table that keeps track of year only in the format "2005". I'm using postgresql 7.4 in case that makes a difference. Is there a way in the sql to compare these? Will the database know that I'm comparing two dates? I wanna return only records in tbl2 that have similar years:

record1 2002
record2 2003
record3 2004
record4 2005

Would return : 2005