timestampdiff

The procedure in Listing 22 demonstrates the solidDB scalar function TIMESTAMPDIFF, used in an assignment statement.

清单 22 中的过程演示了 solidDB 标量函数 TIMESTAMPDIFF，用于一条复制语句。

In Listing 22, the native solidDB function TIMESTAMPDIFF in is written using the format of {fn TIMESTAMPDIFF (...)}.

在清单22中，原生soliddb函数TIMESTAMPDIFF是使用{fn TIMESTAMPDIFF(…)}格式编写的。

The solution for aggregation of timestamp durations is to use TIMESTAMPDIFF, a built-in UDF (user defined function) that is included with DB2 UDB, as shown in the following example.

解决持续时间的聚合问题可以使用 TIMESTAMPDIFF，如下面的样本实例中所显示，它是使用 DB2 UDB 实现的嵌入式 UDF（用户定义的功能）。