How to fetch date(d,m,y) from phpmyadmin in php?
<p>I want to fetch date format from (y,m,d) to (d,m,y).In my database I already insert data like date and images so many around 400 images.I dun want to insert again.<a href="https://i.stack.imgur.com/4q9LR.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4q9LR.jpg" alt="phpmyadmin"></a></p>

<p>The following  is to fetch from database.</p>

<pre><code>&lt;?              
                            $sql = "SELECT * FROM  ShowFillter GROUP BY Image_Date order by Image_Date desc";
                            $objQuery = mysql_query($sql) or die ("Error Query [".$sql."]");
                            while($objResult1 = mysql_fetch_array($objQuery))
                            {
                        ?&gt;
                        &lt;li class="filter" data-filter="&lt;?=$objResult1['Image_Date'];?&gt;"&gt;
                            &lt;a href="#"&gt;
                                &lt;?=$objResult1['Image_Date'];?&gt;&lt;/a&gt;
                        &lt;/li&gt;

                        &lt;? 
                            }    
                        ?&gt;
</code></pre>

<p>The following is i tried it out to fetch from database.But It only show (Year ,Month,day) format.</p>

<pre><code>&lt;?              
                            $sql = "SELECT * FROM  ShowFillter GROUP BY DATE_FORMAT(Image_Date, '%d/%m/%Y') order by DATE_FORMAT(Image_Date, '%d/%m/%Y') desc";
                            $objQuery = mysql_query($sql) or die ("Error Query [".$sql."]");
                            while($objResult1 = mysql_fetch_array($objQuery))
                            {
                        ?&gt;
                        &lt;li class="filter" data-filter="&lt;?=$objResult1['Image_Date'];?&gt;"&gt;
                            &lt;a href="#"&gt;
                                &lt;?=$objResult1['Image_Date'];?&gt;&lt;/a&gt;
                        &lt;/li&gt;

                        &lt;? 
                            }    
                        ?&gt;
</code></pre>

<p>Here is the result 
<a href="https://i.stack.imgur.com/95D1J.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/95D1J.jpg" alt="result"></a>
Is it possible to fetch (day,month,year) format?
If its possible ,guide me please.</p>

<p>Thanks :)</p>