P E N C I L
Login
SQL date
  1. sysdate - correct to seconds
  2. to_char(date, 'YYMMDD HH24:MI:SS0)
  3. select to_char(sysdate-(1.0/1440), 'YYMMDD HH24:MI:SS') from dual;
  4. Operation
    1. Minus 5 minutes: sysdate-(1.0/1440)