How to fetch date from string format

Question

We have an entry in database for an event time left as P1DT3H53M45S, This means 1 day, 3 hours 53 min and 45 sec. I wan to retrieve date from this format.

I can retrieve the duration left by exploding this string and the calculate and then add to current time and create date.

Is there a better way to find the duration left other than exploding ?

I don't understand how you can explode such string as P1DT3H53M45S. by what separator? — hindmost
– hindmost, Commented Sep 18, 2014 at 8:04
That's just a DateInterval format... why not pass it to its constructor... — Elias Van Ootegem
– Elias Van Ootegem, Commented Sep 18, 2014 at 8:06

Kevin · Accepted Answer · 2014-09-18 08:04:42Z

2

No need for explode. Use DateInterval instead:

$interval = new DateInterval('P1DT3H53M45S');
echo $interval->format('%d day, %h hours, %I minutes, %s seconds');
// 1 day, 3 hours, 53 minutes, 45 seconds

answered Sep 18, 2014 at 8:04

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Glavić · Accepted Answer · 2014-09-18 08:08:11Z

1

P1DT3H53M45S is not date, but interval. You can use DateInterval class to create a DateInterval object, from which you can format it, or add it to some of your date.

$interval = new DateInterval('P1DT3H53M45S');
print_r($interval);

# format it
echo $interval->format('%d days, %h hours, %i minutes, %s seconds');

# add it to some date
$dt = new DateTime;
$dt->add($interval);
echo $dt->format('Y-m-d H:i:s');

demo

answered Sep 18, 2014 at 8:08

Glavić

43.6k13 gold badges79 silver badges108 bronze badges

Collectives™ on Stack Overflow

How to fetch date from string format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related