Convert PostgreSQL timestamp to human readable date.

gistfile1.php

<?php

// Convert PostgreSQL timestamp to human readable date
function fnDisplay_Timestamp($sDT)
{
  // Assuming $sDT is in format: YYYY-MM-DD HH:MM:SS.MS
  if(empty($sDT))
    fnErr("No parameter passed to fnDisplay_Timestamp() function.");
    
  $aDT = explode(' ', $sDT);
  if(count($aDT) != 2)
    fnErr("Invalid parameter passed to fnDisplay_Timestamp() function.");
    
  $sDate = $aDT[0];
  $sDate = substr($sDate, 5, 2).'/'.substr($sDate, 8, 2).'/'.substr($sDate, 0, 4);
  return $sDate;
}

?>