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