SELECT
ORDERID,
INTERNTIMESTAMP,
TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS:FF3') AS exact_string,
TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF6') AS with_micros,
DUMP(DBMS_LOB.SUBSTR(INTERNFIXSTRING, 20, 1)) AS first_20_bytes
FROM CACHECPLSORDER
WHERE TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') LIKE '2012-05-21 19:28:19%'
ORDER BY INTERNTIMESTAMP;
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)