Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Get LOCALTIMESTAMP

SQL> --LOCALTIMESTAMP() SQL> SQL> SELECT  LOCALTIMESTAMP FROM dual; LOCALTIMESTAMP --------------------------------------------------------------------------- 16-SEP-06 08.35.05.062000 PM SQL>