> update blah
> set date = date '07.02.2005'

The statement above would use implicit cast.
The more obvious advantage is with date arithmetic, like

update blah
set adate = date '07.02.2005' + 1;

instead of usual

update blah
set adate = cast('07.02.2005' as date) + 1;


Ivan