Oracle获取当前时间
SQL>  select to_char(sysdate,'yyyy-MM-dd-hh-mm-ss') from dual;
TO_CHAR(SYSDATE,'YY ------------------- 2011-12-28-08-12-12
SQL> select to_char(current_timestamp,'yyyy-MM-dd-hh-mm-ss') from dual;
TO_CHAR(CURRENT_TIM ------------------- 2011-12-28-08-12-47
TO_CHAR(SYSDATE,'YY ------------------- 2011-12-28-08-12-12
SQL> select to_char(current_timestamp,'yyyy-MM-dd-hh-mm-ss') from dual;
TO_CHAR(CURRENT_TIM ------------------- 2011-12-28-08-12-47
 
                    
                     
                    
                 
                    
                 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号