"6/8/2013 1:02:37 AM" converted to unix timestamp

[gamefreak13]

I know I can use strtotime(), but I would feel safer specifying the format. How do I convert "6/8/2013 1:01:27 AM" into a unix time stamp while specifying "M/D/Y H:M:S (am/pm)" format?

$date = strtotime('6/8/2013 1:01:27 AM');

echo $date;

[cpd]

$date = "6/8/2013 1:01:27 AM";

$date = DateTime::createFromFormat("d/n/Y g:i:s A", $date);

echo $date->format("FORMAT");

Edited June 8, 2013 by cpd

[gamefreak13]

Is there a way to do this prior to PHP 5.3? I have PHP 5.2.9 and DateTime is not available.

 

Fatal error: Call to undefined method DateTime::createfromformat()

[requinix]

If you're not on Windows, strptime.

[kicken]

You could also manually parse it with a regex and use mktime

[Barand]

or

$d = '6/8/2013 1:01:27 PM';

list($m, $d, $y, $h, $i, $s, $a) = sscanf($d, '%d/%d/%d %d:%d:%d %s');

echo sprintf('%4d-%02d-%02d %02d:%02d:%02d', $y, $m, $d, $a=='AM'?$h:$h+12, $i, $s);  //--> 2013-06-08 13:01:27

[Barand]

Don't store your dates as unix timestamps - store them as type DATETIME, format "yyyy-mm-dd hh:ii:ss"

[Jessica]

Don't store your dates as unix timestamps - store them as type DATETIME, format "yyyy-mm-dd hh:ii:ss"

Since we still don't have images on mobile view I will have to "like" this via a quote. *liked*

[salathe]

I know I can use strtotime(), but I would feel safer specifying the format.

Why would you feel safer? strtotime() has a finite list of formats that it will accept, yours is one of them.

[gamefreak13]

$d = '6/8/2013 1:01:27 PM';

list($m, $d, $y, $h, $i, $s, $a) = sscanf($d, '%d/%d/%d %d:%d:%d %s');

echo sprintf('%4d-%02d-%02d %02d:%02d:%02d', $y, $m, $d, $a=='AM'?$h:$h+12, $i, $s);  //--> 2013-06-08 13:01:27

 

 

I tried this and it seems to work fine, thank you.

 

Need I worry about varying lengths breaking this? If I'm understanding your code correctly, it searches for forward slashes and semi-colons to seperate the year, month, day, etc. I'll do some testing (like throwing 06/08/2013 at it instead of 6/8/2013), but thought I'd ask too.

Edited June 10, 2013 by gamefreak13