This code displays date as: 13-07-2016 I want to display only month and year. Example: "July 2016" How do I modify this code so that it gets Only month and year and displays it. Code:
<td><?=$this->wll->getDateFormate(6,$row['bill_date'])?></td>
此代码显示日期：13-07-2016 我想只显示月份和年份。 示例：“2016年7月” 如何修改此代码以使其仅显示月份和年份并显示它。 编码：
＆lt; td＆gt;＆lt;？= $ this-＆gt; wll-＆gt; getDateFormate（6，$ row ['bill_date']）？＆gt;＆lt; / td＆gt;
微信扫一扫$date = $row['bill_date'];
$month = date('F', strtotime($date));
$year = date('Y', strtotime($date));
<td><?php echo $month . ' ' . $year; ?></td>
Try using a switch on your display text. Something like this:
var month_number = display_text[3] + display_text[3];
var month;
switch (month_number)
case "01":
month = "Jan";
break;
...
And display thath month with the other characters, like:
show: display_text[0] + display_text[1] + "-" + month + ...
Use strtotime():
$time=strtotime($dateValue);
$month=date("F",$time);
$year=date("Y",$time);
Or you can do something like...
$dateElements = explode('-', $dateValue);
$year = $dateElements[0];
echo $year; //2012
switch ($dateElements[1]) {
case '01' : $mo = "January";
break;
case '02' : $mo = "February";
break;
case '03' : $mo = "March";
break;
.
.
.
case '12' : $mo = "December";
break;
}
echo $mo; //January
In that case amend your query to provide that data you want to use rather than trying to manipulate it post query
SELECT DATE_FORMAT(theDateCol, '%M %Y') as theMonthAndYear, ...
date_format($row['bill_date], "F Y");
F -> Full Month Letters and Y -> 4 digit Year