Oracle timestamp cannot display detailed data on the client side

Shulou Source: shulou.com Published: 2022-06-01 18:37:16 10月03日 Update

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;