On 22 June 2011 15:05, David Nicholls <dcn@xxxxxxxxxxxxxx> wrote:
> 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
<?php
$data = '22/06/2011 9:47:20 PM';
$format = 'd/m/Y g:i:s A';
$datetime = DateTime::createFromFormat($format, $data);
echo date('r', $datetime->getTimestamp());
?>
outputs ...
Wed, 22 Jun 2011 21:47:20 +0100
--
Richard Quadling
Twitter : EE : Zend : PHPDoc
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
