Select systemestamp from dual; pay attention to the interception of the string, it is better to use sysdate select to_char (SystimeStamp, 'YYYY-MM-DD HH24: MI: SS') from Dual // Very Import! ! ! Regarding the issue of the date of the database, this statement is very important. If you don't touch the questions from 2004-12-30 and 2005-1-7, it is not good!