Development Experience

Tuesday, April 28, 2015

System Time to varchar in Oracle

You can use the following code to get system time as varchar in Oracle
ls_current_timestamp     VARCHAR2 (14) := SUBSTR (TO_CHAR (SYSTIMESTAMP, 'HH24:MI:SSxFF'), 1, 14);

No comments:

Post a Comment