TO_CHAR(INTERNTIMESTAMP, 'Mon FMDD YYYY') || ' ' ||
TO_CHAR(EXTRACT(HOUR FROM INTERNTIMESTAMP), 'FM00') || ':' ||
TO_CHAR(EXTRACT(MINUTE FROM INTERNTIMESTAMP), '00') || ':' ||
TO_CHAR(TRUNC(EXTRACT(SECOND FROM INTERNTIMESTAMP)), '00') || ':' ||
TO_CHAR(TRUNC(TO_NUMBER(TO_CHAR(INTERNTIMESTAMP, 'FF3')))) ||
TO_CHAR(INTERNTIMESTAMP, 'AM')
Query Filter
Posted on
cleaner
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)