Links:

To Date: 
http://www.techonthenet.com/oracle/functions/to_date.php

To_Timestamp_TZ: 
http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions179.htm