我這個方法有點複雜,你看下吧
SELECT VARCHAR_FORMAT((TIMESTAMP ('1970-01-01-08.00.00.00000')
+ (operationtime/86400000) DAYS
+ (MOD(operationtime,86400000)/3600000) HOURS
+ (MOD(MOD(operationtime,86400000),3600000)/60000) MINUTES
+ (MOD(MOD(MOD(operationtime,86400000),3600000),60000)/1000)SECONDS
+ (MOD(MOD(MOD(MOD(operationtime,86400000),3600000),60000),1000) * 100) MICROSECONDS)
,'YYYY-MM-DD HH24:MI:SS') FROM SYSIBM.SYSDUMMY1;