this based on Sample

I tried to do this:

db2 select firstnme,midinit,lastname,birthdate,YEAR(C
URRENT DATE) - YEAR(birthdate) as age from employee where YEAR(CURRENT DATE) - YEAR(birthdate) between 65 and 1000


It will give me a list who is older than 65

but

db2 select firstnme,midinit,lastname,birthdate,YEAR(C
URRENT DATE) - YEAR(birthdate) as age from employee where YEAR(CURRENT DATE) - YEAR(birthdate) > 65

wont work...

Could anyone tell me why? Thanks

Are you executing this from the command line?

If so you need to surround your query with " , otherwise the '>' will be recognized as a output redirecter.

If not, which message do you get?

oh..yes, u r right... it output to a txt file

As GertK said, put double quotes around the select (but after the DB2 command) if issued from command prompt.

This statement may be more accurate if want their exact age:

SELECT
firstnme,
midinit,
lastname,
birthdate,
year(current date - birthdate) as age
FROM employee
WHERE year(current date - birthdate) >= 65;