Simple date/time question

[phoenixx]

I'm trying to convert the following time stamp: 12:03PM to military time 13:03.

 

I'm using the following code, but it's just outputing 12:03:

$sampledate=("2010-11-08, 12:03PM CST");

$xplodeDateStamp = explode(", ", $sampledate);
$xplodeDate = $xplodeDateStamp[0];
$xplodeTime = $xplodeDateStamp[1];
	echo "Date: " . $xplodeDate . "<br>";
	echo "Time: " . $xplodeTime . "<br>";
	echo "Military Time: " .  date("H:i",strtotime("$xplodeTime"));

[PFMaBiSmAd]

1:03 pm is 13:03 in military time/24 hour format, not 12:03 pm.

[phoenixx]

Okay - oops - here's a more general description of what I need

 

The timestamps I have are g:i AM/PM such as 12:03PM or 3:12AM.  I need to convert those to military 24 hr time w/o AM/PM.  Sorry about the typo

[AbraCadaver]

Okay - oops - here's a more general description of what I need

 

The timestamps I have are g:i AM/PM such as 12:03PM or 3:12AM.  I need to convert those to military 24 hr time w/o AM/PM.  Sorry about the typo

http://us.php.net/manual/en/function.date.php

 

date('G:i', strototime('3:12AM'));

Or use H for leading zeros.

[phoenixx]

Well, it does seem to convert, but it converts 12:03PM to 18:00.  Any thoughts?  Tried to play w/ it a bit, but no change in output.

[PFMaBiSmAd]

Works as expected for me -

echo date('H:i', strtotime('12:03PM'));

 

You would need to post the code that produces the incorrect output for any one here to be able to help you with what it is doing.

[phoenixx]

Here's the code that outputs 18:00.

 

<?
$sampledate=("2010-11-08, 12:03PM CST");

$xplodeDateStamp = explode(", ", $sampledate);
$xplodeDate = $xplodeDateStamp[0];
$xplodeTime = $xplodeDateStamp[1];
	echo "Date: " . $xplodeDate . "<br>";
	echo "Time: " . $xplodeTime . "<br>";
	echo "Military Time: " .  date('G:i', strtotime('$xplodeTime'));
?>

 

This code outputs:

Date: 2010-11-08

Time: 12:03PM CST

Military Time: 18:00

[AbraCadaver]

echo '$xplodeTime';
//and
echo "$xplodeTime";
//and
echo $xplodeTime;

[PFMaBiSmAd]

The reason you are getting a zero minutes value is because you have single quotes around the $xplodeTime variable in the strtotime('$xplodeTime') code and php variables are not replaced with their value when inside of a single-quoted string.

 

The reason you are getting the wrong hour is because you are specifying a time zone in the value (CST) that is different than the time zone setting that php is using and php is adjusting the number of seconds that strtotime() returns to your current time zone setting.

[phoenixx]

Removing the single quotes did it!  Many thanks to all! 

 

Here's the final code and output for anyone researching it:

$sampledate=("2010-11-08, 4:03PM CST");

$xplodeDateStamp = explode(", ", $sampledate);
$xplodeDate = $xplodeDateStamp[0];
$xplodeTime = $xplodeDateStamp[1];
	echo "Date: " . $xplodeDate . "<br>";
	echo "Time: " . $xplodeTime . "<br>";
	echo "Military Time: " .  date('G:i', strtotime($xplodeTime));

 

Outputs:

Date: 2010-11-08

Time: 4:03PM CST

Military Time: 16:03

[AbraCadaver]

Good catch on the timezone.  Worked for me because I'm in CST   No need for the explodes either, let the functions work for you:

 

$sampledate = "2010-11-08, 12:03PM";
$timestamp = strtotime($sampledate);

echo "Date: " . date('Y-m-d', $timestamp) . "<br>";
echo "Time: " . date('g:i', $timestamp) . "<br>";
echo "Military Time: " .  date('G:i', $timestamp);

 

You can use date_default_timezone_set() to force calculations in a specific timezone.