update date and keep time

select TO_CHAR((date '2010-01-02' + (sysdate-trunc(sysdate))),'YYYY-MM-DD HH:mi:ss') from dual;

posted @ 2019-01-03 10:21  kakaisgood  阅读(126)  评论(0)    收藏  举报