插入数据库(更新到时分秒):
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")