3 lines
251 B
SQL
3 lines
251 B
SQL
-- sysdate.sql - Display SYSDATE in Filename safe format and in YYYY-MM-DDTHH24:MI:SS UTC format
|
|
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD"T"HH24.MI.SS"Z"') AS filename_safe_format, TO_CHAR(SYSDATE, 'YYYY-MM-DD"T"HH24:MI:SS') AS current_utc_time FROM dual;
|