newbie date time question
| From: | David Nicholls | Date: | Wed, 22 Jun 2011 14:05:18 +0000 |
| Subject: | newbie date time question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-313635@lists.php.net to get a copy of this message | ||
I'm trying to convert a date and time string using strtotime()
The date and time strings are the first entry in each line in a csv file in the form:
22/06/2011 9:47:20 PM, data1, data2,...
I've been trying to use the following approach, without success:
function read_data($filename)
{
$f = fopen($filename, 'r');
while ($d = fgetcsv($f)) {
$format = 'd/m/Y h:i:s';
$dt = DateTime::createFromFormat($format, $d[0]);
$data[] = array(strtotime($dt), $d[1]); //convert date/time
}
fclose($f);
return $data;
}
Obviously I'm not getting the $format line right, as the resulting $dt values are empty. (I have previously used this reading process successfully with better behaved date and time strings).
Advice appreciated.
DN