Trim Timestamp XML Tags in DB2 column - Using SQL to query

[Bre035]

I have a project were programmers decided to use XML to code additional fields in order to decrease the number of DB2 Tables. This is caused me to have to learn how to query the XML column that hold the data. I am attempting to pull information for a Case Action that exist in the DB2 Table. The table name is ARTS_OGC_CASE_ACTION_DETAIL. The columns are case_number, case_action_detail_code, case_action_xml

I want to be able to Trim the date fields.

 select  A.case_number,B.Open_Date, B.AGENT_ID, X.*,
DATE(X.startDate) as T
--Date(timestamp_startDate,101) as T
FROM DB2PROD.ARTS_OGC_CASE_ACTION_DETAIL A,
XMLTABLE ('$d/artsQualityOfBusinessReviewBean' passing Case_Action_XML as "d"
columns
 indicatorCode varchar(20) path 'indicatorCode',
 startDate timestamp   path 'startDate',
 dueDate timestamp  path 'dueDate',
 endDate timestamp  path 'endDate',
 frequency varchar (40) path 'frequency',
 completedDate timestamp path 'completedDate') as X,
 DB2PROD.ARTS_CASE_RESEARCH B
WHERE A.CASE_NUMBER = B.CASE_NUMBER 

[NeoPa]

There appears to be no help available from the XML side, as I'm told it's DB2 specific, so let's see if you get more luck here in the DB2 forum.