Oracle中的Round和Trunc
SQL > selectto_char(sysdate,' yyyy-mm-dd hh24:mi:ss ' ) now_date, 2 to_char( Round (sysdate), ' yyyy-mm-dd hh24:mi:ss ' ) round_date,3 to_char(Trunc(sysdate), ' yyyy-mm-dd hh24:mi:ss ' ) trunc_date
4 fromdual;
NOW_DATE ROUND_DATE TRUNC_DATE
-- ------------------------------------ -------------------------------------- ----------------------
2008 - 06 - 30 14 : 52 : 13 2008 - 07 - 01 00 : 00 : 00 2008 - 06 - 30 00 : 00 : 00
页:
[1]