Search notes:

Oracle: PL/SQL package TIM: function RFC_3339_SEC

The function tim.rfc_3339_sec is modelled after the --rfc-3339=sec option of the date shell command. It returns an alphabetically sortable representation of a date without separating date and time with T or appending any fractional seconds or time zone information. 
select
   tim.rfc_3339_sec(sysdate) rfc_3339,
   tim.iso_8601    (sysdate) iso_8601
from
   dual;
--
-- RFC_3339             ISO_8601
-- -------------------- --------------------
-- 2021-07-03 11:19:00  2021-07-03T11:19:00Z

See also

The function tim.iso_8601.
The TIM package.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759397920, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/PL-SQL/libs/personal/tim/rfc_3339_(50): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78