PHP - Converting a string written to a variable to a time format

Question

So I am pulling some data from a internal jsp page with DOMDocument and using a php script to insert that into a database. It pulls the data and I have so far got everything the way I want it, but the time that is output on the page, which is in a string format is in the following format:

12:05:00a //for am
10:15:00p //for pm, obviously

I was thinking I could use strtotime (but I'm open to suggestions). Here is how it is coded:

$cols = $row->getElementsByTagName('td');
$scheduled_time = $cols->item(0)->nodeValue;
echo $scheduled_time;

I know the answer probably very easy, but I haven't had to work much with converting times. It can be in military time as well.

Thanks in advance.

Is there a date element to work with or just time?

Professor Abronsius
– Professor Abronsius

2015-09-14 07:34:12 +00:00
Commented Sep 14, 2015 at 7:34 — Professor Abronsius
– Professor Abronsius, Commented Sep 14, 2015 at 7:34

MaggsWeb · Accepted Answer · 2015-09-14 07:47:05Z

1

You already have a time format. '12:05:00' is fine for inserting into a time field. You do however have an issue witha that last character, determining AM from a, and PM from p.

So, just sort that with a str_replace();

$replaceFrom = array('a', 'p');
$replaceTo   = array(' AM',' PM');

$time = str_replace($replaceFrom,$replaceTo,$scheduled_time);
echo date("H:i", strtotime($time));

answered Sep 14, 2015 at 7:47

MaggsWeb

3,0071 gold badge17 silver badges23 bronze badges

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

Comments

Josip Ivic · Accepted Answer · 2015-09-14 07:35:59Z

0

Try with this

echo date("G:i", strtotime($time));

or you can try like this also

echo date("H:i", strtotime("10:15 PM"));

also, you can try to do this

$date = new \DateTime();
echo date_format($date, 'Y-m-d H:i:s');
#output: 2015-09-14 10:15:00

echo date_format($date, 'G:ia');
#output: 10:15pm

answered Sep 14, 2015 at 7:35

Josip Ivic

3,7099 gold badges42 silver badges58 bronze badges

Collectives™ on Stack Overflow

PHP - Converting a string written to a variable to a time 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