Timestamp field in DB2 Query.

[jtrapat1]

I'm running a query - it will eventually be a
DELETE FROM tablename WHERE a timestamp field has a '1994' or less, year in the first four positions.
I need help writing this query:
I don't know which functions, if any, I need to use to pull the year out of the table, and then delete the rows.

Can anyone help?
Thanks in advance.

John

 

[PruSQLer]

If you're talking about a regular date field just say

Where year(datefield) < 1995