# MySql date format/php form

**URL:** <https://forum.kirupa.com/t/mysql-date-format-php-form/190057>\
**Category:** programming\
**Created:** [June 8, 2006, 9:17am UTC](https://forum.kirupa.com/t/mysql-date-format-php-form/190057 "2006-06-08T09:17:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onemhunki](https://avatars.discourse-cdn.com/v4/letter/o/c57346/32.png) [@onemhunki](https://forum.kirupa.com/u/onemhunki)\
**Post date:** [June 8, 2006, 9:17am UTC](https://forum.kirupa.com/t/mysql-date-format-php-form/190057/1 "2006-06-08T09:17:28Z")

</div>

Hi folks,

I’ve got a PHP form to edit a record in a database, I need the user to be able to enter the date in the european format, ie: 30/11/06. I can get the date to display in this way using the Unix Timestamp but the database will not interperet this this way and displays a random date format.

Any help/advice on this topic as usual greatly appreciated.

Ta.