SELECT timestampdiff('d',
to_timestamp(acpt_time,'yyyy-mm-dd hh24:mi:ss'),
to_timestamp(nvl(arc_time,to_char(CURRENT_TIMESTAMP,'yyyy-mm-dd hh24:mi:ss')),'yyyy-mm-dd hh24:mi:ss')
) FROM table;
vertica 时间处理
于 2024-07-05 19:45:03 首次发布