随笔分类 -  Oracle

常用SQL
摘要：查询前一天 select sysdate 1 from dual; 更新创建日期为前一天 update dis_specimen a set a.create_time = sysdate 1 where a.barcode in (201810260400,201810260300,2018102 阅读全文
posted @ 2018-10-26 11:09 Philly008 阅读(96) 评论(0) 推荐(0)