How many times the function of to_date will be executed when run the following query? Will it run 1000000 times? will Oracle cache the result of the function? How can we approve whether to_date run 1000000 times or just once?

select to_date('20070817','YYYYMMDD') from tab_with_1000000 rows