oracle timestamp的转换

select to_char(stime,'yyyy-mm-dd HH24:MI:ss.ff3') from e_bmp_log_operation t where t.sdetail like '%30993%' and soperation = 'insertMember';

posted @ 2013-09-23 15:11  holycrap  阅读(499)  评论(0)    收藏  举报