Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select to_char( sysdate, DDMMYY HH24

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