使用PHP从时间戳中提取正确的月份

Question

got stuck in extracting the correct month from timestamp...Here's my Code

$sql = "SELECT id,notice,description,DAY( `posted_date` ) AS DAY, MONTH(`posted_date` ) AS MONTH, YEAR( `posted_date`) AS YEAR, enable FROM n_notice";
                                $result=mysqli_query($con,$sql);

                                while ($run = mysqli_fetch_array($result,MYSQLI_ASSOC)) 
                                {
                                    $notice = $run['notice'];   
                                    $description = $run['description'];

                                    $day =$run['DAY'];
                                    //$month=$run['MONTH'];
                                    $month=date("M",$run['MONTH']);
                                    $year=$run['YEAR'];
                            ?>

                            <div class="media">
                                <div class="media-left media-middle">
                                    <div id="date">
                                        <div class="mon"><?php echo $month;?></div>
                                        <div class="day"><?php echo $day;?></div>
                                        <div class="year"><?php echo $year;?></div>
                                    </div>
                                </div>
                                <div class="media-body">
                                    <h5 class="media-heading"><?php echo $notice; ?></h5>
                                    <?php echo $description; ?>
                                  </div>
                            </div>
                            <?php
                                }
                                // Free result set
                                mysqli_free_result($result);
                            ?>
                        </div>

DB timestamp column

How to get the correct month in "M" format? All the Months are shown as "Jan"!!!

Answer 1

$month=date("M",$run['MONTH']);

Try to change "M" to "F".

F - A full textual representation of a month (January through December)