Oracle PL/SQL To_Date Function The To_Date function converts a string to a date. The To_Date Function syntax: to_date( string, [ format_mask ], [ nls_language ] ) Example select to_date('2008/08/21', 'yyyy/mm/dd') from dual; 8/21/2008 select to_date('082111', 'MMDDYY') from dual; 8/21/2011 select to_date(sysdate,...
Oracle PL/SQL To_Char Function The To_Char function converts a number or date to a string. The To_Char Function syntax: to_char( value, [ format_mask ], [ nls_language ] ) Example select to_char(2199.85, '9999.9') from dual; 2199.9 select to_char(2199.85, '9999.99') from dual; 2199.85...
Oracle PL/SQL SysTimestamp Function The SysTimestamp returns a TIMESTAMP WITH TIME ZONE. The SysTimestamp Function syntax: systimestamp Example Select systimestamp From dual; 01-05-2018 22:21:56,409000000 +03:00...
Oracle PL/SQL Sysdate Function The Sysdate returns the current system date and time on from the database. The Sysdate Function syntax: sysdate Example Select sysdate From dual; 01-05-2018 22:21:19...
Oracle PL/SQL Sys_Context Function The Sys_Context function returns the user_id from the current Oracle session. The Sys_Context Function syntax: sys_context( namespace, parameter, [ length ] ) Parameters: ACTION, AUDITED_CURSORID, AUTHENTICATED_IDENTITY, AUTHENTICATION_DATA, AUTHENTICATION_METHOD, AUTHENTICATION_TYPE, BG_JOB_ID, CLIENT_IDENTIFIER, CLIENT_INFO, CURRENT_BIND, CURRENT_SCHEMA, CURRENT_SCHEMAID, CURRENT_SQL, CURRENT_SQL_LENGTH,...