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)

  5. First day of month:
    select (to_char(sysdate, 'YYYY-MM') || '-01')::date