No need to search/replace on every line when you can just output the correct data in the first place!
Code:
select julianday("now") - julianday(date_field) as age_in_days
select cast(julianday("now") - julianday(date_field) as int) as age_in_whole_days