Re: newbie date time question
| From: | Shawn McKenzie | Date: | Wed, 22 Jun 2011 15:35:30 +0000 |
| Subject: | Re: newbie date time question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-313644@lists.php.net to get a copy of this message | ||
On 06/22/2011 09:05 AM, David Nicholls 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
I'm late to the party, but strtotime works great, though you need to
give it what it expects:
$ts = strtotime(str_replace('/', '-', $date));
--
Thanks!
-Shawn
http://www.spidean.com