ORACLE 时间修约的问题 急!!!

Question

我想把系统时间秒变为零,分钟位取到十位,这个语句该怎么写如想把 2008-03-03 08:33:52   变成  2008-03-03 08:30:00  请各位高手帮忙

Answer 1

select substr(to_char(sysdate,'YYYY-MM-DD hh24:mi:ss'),1,15)||'0:00' from dual;

Answer 2

SQL> select sysdate, trunc(sysdate, 'MI') from dual;SYSDATE             TRUNC(SYSDATE,'MI')                                         
------------------- -------------------                                         
2008-03-04 09:29:36 2008-03-04 09:29:00    

Answer 3

SQL> select sysdate, trunc(sysdate, 'hh') + numtodsinterval(round(to_number(to_char(sysdate, 'mi')), -1), 'minute') from dual
  2  /SYSDATE             TRUNC(SYSDATE,'HH')                                         
------------------- -------------------                                         
2008-03-04 09:50:52 2008-03-04 09:50:00