# Simple date question

**URL:** <https://forum.kirupa.com/t/simple-date-question/55150>\
**Category:** Uncategorized\
**Created:** [June 21, 2004, 3:53pm UTC](https://forum.kirupa.com/t/simple-date-question/55150 "2004-06-21T15:53:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mid\_ori](https://avatars.discourse-cdn.com/v4/letter/m/7cd45c/32.png) [@mid\_ori](https://forum.kirupa.com/u/mid_ori)\
**Post date:** [June 21, 2004, 3:53pm UTC](https://forum.kirupa.com/t/simple-date-question/55150/1 "2004-06-21T15:53:49Z")

</div>

hi, i have a simple date question, i’m new to using php and mysql and with the help of books and website have developed a little news feed, but the date is not showing how i want it to, currently its [COLOR=Red]“2004-06-21 16:37:12”[/COLOR] but i want to view it like [COLOR=Red]june 2004[/COLOR] below is the code i have used all help appericated.

```php

<?php
$conn = mysql_connect('xxxxx', 'xxxxx', 'xxxxx')
	or die(mysql_error());
mysql_select_db("xxxxxxxx", $conn) or die(mysql_error());

// create the SQL statement
$sql = "SELECT * FROM news ORDER BY news_create_time DESC";

// execute the SQL statement
$result = mysql_query($sql, $conn) or die(mysql_error());

//go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
	// give a name to the fields
    $news_title = $newArray['news_title'];
    $news_text = $newArray['news_text'];
	$news_create_time = $newArray['news_create_time'];
    //echo the results onscreen
    echo "<font color=\"#FF0000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">$news_title<br><br>$news_text<br><br>$news_create_time<br><br></font>";
}
?>

```