Date formating from ODBC

[mr_zog]

I am looking for some help on this one. I am coding a page in PHP that is connecting to a MsSQL (needed to be that way for the other program that feeds the data into it).

I am trying to pull data from a couple of fields that are datetime fields and format them. I am currently getting a YYYY-MM-DD HH:MM:SS.sss back.

Does anyone know the best way to break this down. I am probably missing something very obvious but my brain hurts from the other things I am doing:rolleyes:

[sarahk]

Just write a little function such as:

// at the top of your script
function makeDate($orig)
{
  $outDate = substr($orig,a,b);  

  $outDate .= substr($orig,c,d);
  // and so on until you have the bits you need in the order you need them
  return $outDate;
}
//then in your record handling
$myDate = makeDate($db->record["date"]);

please excuse syntax errors - working with another language today - but this should give you the idea