dtdvlazd56637 2014-06-06 03:09
浏览 66
已采纳

将日期字符串转换为正确的格式[重复]

This question already has an answer here:

I am importing data from and excel sheet and the dates are formatted like so:

May 5, 2014

I need to convert this to a proper PHP date format like:

Y-m-d

This isn't working:

$new_date = date('Y-m-d', strtotime('May 5, 2014'));
echo $new_date;

Results 1969-12-31

I was thinking that i could do something like this:

$old_date = 'May 5, 2014';
$old_date = str_replace(',', '', $old_date);
$old_date_parts = explode(' ',$old_date);

// Convert month name to number
$may = '5';

// Build new date
$new_date = $old_date_parts[2].'-'.$may.'-'.$old_date_parts[1];

But there HAS to be another way!

Please help. Thank you in advance.

EDIT

Seems that the PHPExcel that i am using doesn't have the function to convert a serial date to a unix time so i used this.

UNIX_DATE = (EXCEL_DATE - 25569) * 86400
</div>
  • 写回答

1条回答 默认 最新

  • dongzhui2636 2014-06-06 03:11
    关注
    $date = date_create_from_format('M j, Y', 'May 5, 2014');
    echo date_format($date, 'Y-m-d');
    

    Or OOP Style

    $date = DateTime::createFromFormat('M j, Y', 'May 5, 2014');
    echo  $date->format('Y-m-d');
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题