Shulou(Shulou.com)06/01 Report--

Use the following statement: O_CHAR(pubtime,'yymmdd HH:mm: ss'), for example:

select id,TO_CHAR(pubtime,'yymmdd HH:mm:ss'),content from bj_ref.gz_twinfo_ref where user_id=2603 and TO_CHAR(pubtime,'yyymmdd HH:mm:ss')>='20140704 20:58:42' and author ='Southern Daily' order by id asc;

That's it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.