Question & Answer
Question
When writing a query, how do you get the date and/or time part of a timestamp attribute where the underlying database is DB2®?
[{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB2 Information Integrator for Content","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.1;8.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Retrieve Issues","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"","label":"Windows 2000"},{"code":"","label":"Windows NT"}],"Version":"8.1;8.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Content Manager Enterprise Edition
Software version:
8.1, 8.2
Operating system(s):
AIX, Solaris, Windows
Document number:
80699
Modified date:
06 July 2019
UID
swg21191436
Manage My Notification Subscriptions