IBM Support

TIMESTAMPDIFF_BIG built-in scalar function

News


Abstract

The TIMESTAMPDIFF_BIG built-in scalar function provides an alternative to TIMESTAMPDIFF, and is able to handle any granularity and scale of timestamp comparison.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > TIMESTAMPDIFF_BIG scalar function




 

timestamp difference

See the SQL Reference for details: TIMESTAMPDIFF_BIG


[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]

Document Information

More support for:
IBM i

Component:
IBM i Db2

Software version:
7.4.0, 7.5.0 and future releases

Operating system(s):
IBM i

Document number:
6828073

Modified date:
26 March 2025

UID

ibm16828073

Manage My Notification Subscriptions