13

How can I convert this string 05/Feb/2010:14:00:01 to unixtime ?

hakre
  • 184,866
  • 48
  • 414
  • 792
streetparade
  • 30,574
  • 35
  • 99
  • 121

9 Answers9

53

Use the strtotime function:

Example:

 $date = "25 december 2009";
 $my_date = date('m/d/y', strtotime($date));
 echo $my_date;
Sarfraz
  • 367,681
  • 72
  • 526
  • 573
  • @streetparade: i mean for example you can not pass to it all sorts of strings for the date eg "28 of the December two thousand ten" – Sarfraz Feb 08 '10 at 16:10
  • It's worth noting strtotime also supports key words and phrases like 'yesterday' or 'this day next week' ;p – Rowan Feb 08 '10 at 17:34
20

For PHP 5.3 this should work. You may need to fiddle with passing $dateInfo['is_dst'], wasn't working for me anyhow.

$date = '05/Feb/2010:14:00:01';
$dateInfo = date_parse_from_format('d/M/Y:H:i:s', $date);
$unixTimestamp = mktime(
    $dateInfo['hour'], $dateInfo['minute'], $dateInfo['second'],
    $dateInfo['month'], $dateInfo['day'], $dateInfo['year'],
    $dateInfo['is_dst']
);

Versions prior, this should work.

$date = '05/Feb/2010:14:00:01';
$format = '@^(?P<day>\d{2})/(?P<month>[A-Z][a-z]{2})/(?P<year>\d{4}):(?P<hour>\d{2}):(?P<minute>\d{2}):(?P<second>\d{2})$@';
preg_match($format, $date, $dateInfo);
$unixTimestamp = mktime(
    $dateInfo['hour'], $dateInfo['minute'], $dateInfo['second'],
    date('n', strtotime($dateInfo['month'])), $dateInfo['day'], $dateInfo['year'],
    date('I')
);

You may not like regular expressions. You could annotate it, of course, but not everyone likes that either. So, this is an alternative.

$day = $date[0].$date[1];
$month = date('n', strtotime($date[3].$date[4].$date[5]));
$year = $date[7].$date[8].$date[9].$date[10];
$hour = $date[12].$date[13];
$minute = $date[15].$date[16];
$second = $date[18].$date[19];

Or substr, or explode, whatever you wish to parse that string.

erisco
  • 13,808
  • 2
  • 38
  • 43
4

You should look into the strtotime() function.

Johannes Gorset
  • 8,565
  • 4
  • 35
  • 34
4

http://www.php.net/date_parse_from_format

Vladislav Rastrusny
  • 28,763
  • 23
  • 91
  • 155
2
$d="05/Feb/2010:14:00:01";
$dr= date_create_from_format('d/M/Y:H:i:s', $d);
echo $dr->format('Y-m-d H:i:s');

here you get date string, give format specifier in ->format() according to format needed

Dashrath
  • 2,091
  • 1
  • 26
  • 33
1

Simple exploding should do the trick:

$monthNamesToInt = array('Jan'=>1,'Feb'=>2, 'Mar'=>3 /*, [...]*/ );
$datetime = '05/Feb/2010:14:00:01';
list($date,$hour,$minute,$second) = explode(':',$datetime);
list($day,$month,$year) = explode('/',$date);

$unixtime = mktime((int)$hour, (int)$minute, (int)$second, $monthNamesToInt[$month], (int)$day, (int)$year);
dev-null-dweller
  • 28,932
  • 3
  • 63
  • 85
0

If you're up for it, use the DateTime class

axsuul
  • 7,163
  • 8
  • 52
  • 70
0

If it's a string that you trust meaning that you have checked it before hand then the following would also work.

$date = new DateTime('2015-03-27');
Rick
  • 11,494
  • 2
  • 42
  • 41
0

Try this:

$new_date=date('d-m-Y', strtotime($date));
Jason Plank
  • 2,342
  • 4
  • 32
  • 40
enor
  • 39
  • 1
  • This is downvoted due to redundancy. The answer itself is correct, but was previously provided on Feb 8 by Sarfraz. – a coder Sep 20 '12 at 15:21