TO_NUMBER (data; ) to an integer.

To _ data ('20090101','yyyymmdd') is converted to a time type.

Of course, there are also functions that transpose other types of strings: TO_CHAR.