DEV Community

Query Filter
Query Filter

Posted on

ora11

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;

Top comments (0)