字符串转时间戳
values (timestamp_format(
'2012/12/12 15:10:10.123456'
,'yyyy-mm-dd hh24:mi:ss.ff'))
select timestamp('03/22/2023', '09:26:51') from sysibm.sysdummy1"
--------------------------
2023-03-22-09.26.51.000000
1 record(s) selected.
计算时间差
values (timestampdiff(4,
char(
timestamp('2013-03-26-10.07.24.123456')-
timestamp('2013-03-01-10.10.10.123000'))))