select to_date(‘01.01.2008’, ‘DD.MM.YYYY’) + to_number(‘FF’, ‘XX’)
from dual
===
trunc(sysdate)

===

Another beer, please!