Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select to_char(sysdate,DD-MON-YY HH24

SQL> SQL> select to_char(sysdate,'DD-MON-YY HH24:MI:SS' ) "Right Now"   2  from dual   3  / Right Now ------------------ 16-JUN-08 17:28:40 1 row selected. SQL> SQL> SQL> --