Fetching the data from STR_TO_DATE

[yoda699]

I'm sending some information to mysql server to format a string into datetime format that the server can understand. I'm running into problems regarding fetching that data.

$connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error());
      mysql_select_db(DB_NAME, $connection) or die(mysql_error());
$newSqlDate = "SELECT STR_TO_DATE('$newDateTime', '%m/%d/%Y %h,%i,%p');"; 
  $result = mysql_query($newSqlDate);
$row = mysql_fetch_array($result) or die(mysql_error());
  echo "Date and Time: ".$row['datetime'];
mysql_close($connection);

 

My echo returns only: "array"

 

Thanks

[fenway]

Don't double-post.