Page 1 of 1

How do I concatenate date and time from xml document?

Posted: Fri Feb 15, 2019 9:04 pm
by winkimjr2
I need help to concatenate HearingDate and StartTime in this format: YYYY-MM-DDT00:00:00-06:00. How do I do it in xslt?

Xml document

Code: Select all

<Hearing>
<Setting>
<HearingDate>07/07/2105</HearingDate>
<CourtSessionBlock>
<StartTime>10:30 AM</StartTime>
<EndTime>11:00 AM</EndTime>
</CourtSessionBlock>
<TimestampCreate>12/10/2018 09:14:18:883</TimestampCreate>
<TimestampChange>12/10/2018 09:14:58</TimestampChange>
</Setting>
</Hearing>

Output

Code: Select all

<HearingDatetimeStart>2015/01/31T10:30:00-06:00</HearingDatetimeStart>