oracle日期格式问题

select to_char(rq,'yyyy-mm-dd hh24:mi:00') from table1;
错误：日期格式无法识别，我想把秒级的时间显示成00
怎么改啊，帮我看看

---

select to_char(trunc(rq,'mi'),'yyyy-mm-dd hh24:mi:ss') from table1;

---

select to_char(rq,'yyyy-mm-dd hh24:mi:ss') from table1;

---

SQL code:
SELECT TO_CHAR(rq,'yyyy-mm-dd hh24:mi')||':00' from table1

---

引用

SQL codeSELECT TO_CHAR(rq,'yyyy-mm-dd hh24:mi')||':00'from table1

up

---

select to_char(trunc(sysdate,'mi'),'yyyy-mm-dd hh24:mi:ss') from dual;