DB2 SQL calculates time difference and formatting times

Format time

DB2 format time used by To_char (TIMESTAMP (' 2017-10-24 21:18:12 '), ' yyyy-mm-dd ');

Test Sql:select To_char (TIMESTAMP (' 2017-10-24 21:18:12 '), ' Yyyy-mm-dd ') from SYSIBM. DUAL;

Calculate Time Difference

DB2 Calculation time difference use

Timestampdiff (<n>, char (timestamp (' 2017-12-24 00:00:10 ')-timestamp (' 2017-12-24 00:00:05 ')))

Test sql:

Select Timestampdiff (2, char (timestamp (' 2017-12-24 00:00:10 ')-timestamp (' 2017-12-24 00:00:05 ')) from SYSIBM. DUAL;

For <n>, you can use the following values instead to indicate the time unit of the result:
1 = decimal part of seconds
2 = Seconds
4 = Minute
8 = When
16 = Day
32 = Week
64 = Month
128 = Quarter
256 = Year

DB2 SQL calculates time difference and formatting times