How do I concatenate date and time from xml document?

Questions about XML that are not covered by the other forums should go here.
winkimjr2
Posts: 55

How do I concatenate date and time from xml document?

Fri Feb 15, 2019 9:04 pm

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>

Return to “General XML Questions”

Who is online

Users browsing this forum: No registered users and 0 guests