插入数据库(更新到时分秒):
UPDATE TOKEI_IN_BK_CSV SET USR_ID = 'VENAS', YMDT = to_date('2018/04/13
16:17:06','yyyy-mm-dd hh24:mi:ss') WHERE KAI_NEN =2016 AND TO_HO_KB =99 ;q
取出数据:
SELECT DISTINCT TO_CHAR(YMDT,'yyyy-mm-dd hh24:mi:ss') , USR_ID FROM
TOKEI_IN_BK_CSV WHERE KAI_NEN =2016 AND TO_HO_KB =99
(要达到的效果)
VB6.Format(rec, "YYYY/MM/DD HH:NN")
热门工具 换一换