When subtracting 2 datetime fields in a Crystal Command table select statement (statement below)

(dd.draw_start_datetime - d.birthdate)/365.25) as age,

i get data in the following format.

+000000041 22:52:55.890410959

Is there a way to manipulate this to display just the "41"? The 41 represents 41 years.

Note that I have to do this within a Crystal Command table using SQL.

Thank you for taking the time to respond. I received a resolution from an offsite user with the same software.