select count(*) from aaa where
GMT_CREATE >to_date(to_char(TRUNC(SYSDATE),'yyyy-mm-dd')||'08:30:00','yyyy-mm-dd hh24;mi:ss');
select count(*) from aaa where
GMT_CREATE >trunc(sysdate) + 8.50/24 ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-687155/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-687155/