PHP Format date yyyy-mm-ddThh:ii:ss to Y-m-d h:i:s

Question

i need to convert a date with this format (2017-06-14T08:22:29.296-03:00) to Y-m-d H:i:s. I take that date from an xml response from a soap service, And i need to check if the expiration date is less than the actual date.

I have this and works OK on localhost, but when is uploaded to other server, i have validation problems:

if($wsaa->get_expiration() < date("Y-m-d h:m:i")) {
    if ($wsaa->generar_TA()) {
        echo '<br>Nuevo Ticket de Acceso Generado'; 
    } else {
        echo '<br>No se pudo obtener ticket de acceso'; 
    }
} else {
    echo '<br>TA expira:' . $wsaa->get_expiration(); 
}

$wsaa->get_expiration() return 2017-06-14T08:22:29.296-03:00

I tried to format the date but return with a few minutes of diff.

Wouldn't it be easier to just convert both to unix timestamps with `strtotime()` ? — Derek Pollard, Jun 14 '17 at 17:06
Probably more suitable to close with https://stackoverflow.com/questions/2167916/convert-one-date-format-into-another-in-php — Qirel, Jun 14 '17 at 17:09

score 4 · Accepted Answer · answered Jun 14 '17 at 17:04

4

You can use date function for format and use strtotime to convert current date to timestamp that date function needed:

$datetime = '2017-06-14T08:22:29.296-03:00';

$format_date  = date('Y-m-d H:i:s', strtotime($datetime));

answered Jun 14 '17 at 17:04

Mohammad Hamedani

3,304
3
10
22

Thanks, i tried with strtotime() but returned me different time! Now works. Thanks – Gustavo Andriuolo Jun 14 '17 at 17:12

Ravi Gehlot · Answer 2 · 2017-06-14T17:40:50.373

An alternative solution in OOP using Carbon from http://carbon.nesbot.com. If you run my example, you might notice that solution1() is an hour behind. That's the reason why I recommend Carbon is that it plays really well with time-zones.

First run "composer require nesbot/carbon";

<?php
require 'vendor/autoload.php';
use Carbon\Carbon;

class FormatDate 
{   
    protected $dateTime;
    protected $newFormat;

    public function __construct($dateTime, $newFormat) 
    {   
        $this->dateTime = $dateTime;
        $this->newFormat = $newFormat;
    }   

    // Solution 1
    public function solution1()
    {   
        $format_date = date($this->newFormat, strtotime($this->dateTime));

        return $format_date;
    }   

    // Solution 2
    public function solution2()
    {   
        $date = Carbon::parse($this->dateTime)->format($this->newFormat);

        return $date;
    }   
}

$datetime = '2017-06-14T08:22:29.296-03:00';
$newFormat = 'Y-m-d H:i:s';

// Solution 1
echo (new FormatDate($datetime, $newFormat))->solution1();

echo '----------------------------';

// Solution 2
echo (new FormatDate($datetime, $newFormat))->solution2();

PHP Format date yyyy-mm-ddThh:ii:ss to Y-m-d h:i:s

2 Answers2