# \[MySQL\] Date Formating

**URL:** https://forum.kirupa.com/t/mysql-date-formating/137277
**Category:** Uncategorized
**Created:** [February 12, 2005, 11:00pm UTC](https://forum.kirupa.com/t/mysql-date-formating/137277 "2005-02-12T23:00:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jw06](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@jw06](https://forum.kirupa.com/u/jw06)
#### Post date: [February 12, 2005, 11:00pm UTC](https://forum.kirupa.com/t/mysql-date-formating/137277/1 "2005-02-12T23:00:51Z")

</div>

Hmm, I am trying to format a date from my news database. this is my query statement:

```php

$query = "SELECT *, DATE_FORMAT(date_entered, '%c/%e/%y %r:%i') AS formatted_date FROM news ORDER BY date_entered DESC";

```

Any idea what I may have done wrong? or How I can fix this?