How to improve the following SQL select date in RDB

I\'m working on a .Net WinForms appliation that is connecting to a legacy RDB database... Some of the fields for dates are stored as integers (imagine 2010-01-04 was the integer 20100104)