IBM Support

VARCHAR_FORMAT() and TO_CHAR() built-in functions enhanced

News


Abstract

The VARCHAR_FORMAT() and TO_CHAR() scalar functions are enhanced to support two new format elements: MS (millisecond) and US (microsecond)

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > VARCHAR_FORMAT() and TO_CHAR() built-in functions enhanced


See the SQL Reference for details: VARCHAR_FORMAT scalar function

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

Document Information

More support for:
IBM i

Software version:
All Versions

Operating system(s):
IBM i

Document number:
1116705

Modified date:
26 March 2025

UID

ibm11116705

Manage My Notification Subscriptions