# Changing the Date formate?

**URL:** <https://forum.kirupa.com/t/changing-the-date-formate/195936>\
**Category:** Uncategorized\
**Created:** [August 4, 2006, 2:25am UTC](https://forum.kirupa.com/t/changing-the-date-formate/195936 "2006-08-04T02:25:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daimz](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/daimz/32/2383_2.png) [@Daimz](https://forum.kirupa.com/u/Daimz)\
**Post date:** [August 4, 2006, 2:25am UTC](https://forum.kirupa.com/t/changing-the-date-formate/195936/1 "2006-08-04T02:25:01Z")

</div>

I have set up a table in my database for the date and it is set up like this:

Felid=“date” Type=“date” Collation="" attributes="" Null=“yes” default2=“Null” extra=""

And it displays date like this: 2006-08-04 and I am wanting it to be displayed as 04-08-2006 is this possible? and how could I do it?  
also instead of starting a new thread what collation should I have my "text"feild set to at the moment it is Latin1\_Swedish\_Ci and I dont know if that is the one that I should be using for a simple CMS update text feild? but yeh Im mainly worried about the date thing.  
thanx