clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2042902 fiddles created (16642 in the last week).

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
 hidden batch(es)


ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF9';
 hidden batch(es)


SELECT TRUNC( current_timestamp, 'MI' ) - MOD( EXTRACT( MINUTE FROM current_timestamp ), 15 ) * INTERVAL '1' MINUTE - INTERVAL '30' MINUTE + INTERVAL '59' SECOND AS start_time, TRUNC( current_timestamp, 'MI' ) - MOD( EXTRACT( MINUTE FROM current_timestamp ), 15 ) * INTERVAL '1' MINUTE - INTERVAL '15' MINUTE + INTERVAL '59' SECOND AS end_time, current_timestamp FROM DUAL
START_TIME END_TIME CURRENT_TIMESTAMP
2021-07-16 01:15:59 2021-07-16 01:30:59 2021-07-16 01:47:37.612237000
 hidden batch(es)