DEV Community

Query Filter
Query Filter

Posted on

format2

TO_CHAR(EXTRACT(HOUR FROM INTERNTIMESTAMP)) || ':' ||
TO_CHAR(EXTRACT(MINUTE FROM INTERNTIMESTAMP)) || ':' ||
TO_CHAR(TRUNC(EXTRACT(SECOND FROM INTERNTIMESTAMP))) || ':' ||
TO_CHAR(TRUNC(TO_NUMBER(TO_CHAR(INTERNTIMESTAMP, 'FF3')))) ||
TO_CHAR(INTERNTIMESTAMP, 'AM') || '~'

Top comments (0)