Oracle timestamp

　　select systimestamp from dual　　select current_timestamp from dual　　select cast(sysdate as timestamp) "DATE" from dual　　select to_timestamp(to_date(sysdate, 'yyyy-mm-dd')) from dual　　select to_timestamp('2008-11-17 00:31:35'