title: Format Date and Time in XSLT
body: <p>I have the column which returns the date and time in the default format.</p>
  
  <pre><code>&lt;xsl:value-of select="/CAudioFile/CRI/LocalStartTime"/&gt;
  </code></pre>
  
  <p>Which returns </p>
  
  <blockquote>
    <p>2014-05-08T08:01:26.4000000-0700</p>
  </blockquote>
  
  <p>I want to put this time in this format:</p>
  
  <blockquote>
    <p><strong>05/08/2014 08:01:26</strong></p>
  </blockquote>
  
  <p>I have tried to get the format with the different combination of substring:</p>
  
  <pre><code>&lt;xsl:value-of select="substring(/CAudioFile/CRI/LocalStartTime,1,10)"/&gt;
  </code></pre>
  
  <p>But it's either returning me just the date or just the time.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thank you.</p>