# Date from MySQL db

**URL:** <https://forum.kirupa.com/t/date-from-mysql-db/29606>\
**Category:** programming\
**Created:** [August 28, 2003, 4:26pm UTC](https://forum.kirupa.com/t/date-from-mysql-db/29606 "2003-08-28T16:26:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lbeetles](https://avatars.discourse-cdn.com/v4/letter/l/2bfe46/32.png) [@lbeetles](https://forum.kirupa.com/u/lbeetles)\
**Post date:** [August 28, 2003, 4:26pm UTC](https://forum.kirupa.com/t/date-from-mysql-db/29606/1 "2003-08-28T16:26:02Z")

</div>

Hi All,

Does anyone know how to change the way a date field in my MySQL db appears in flash. At the moment it shows up and YYYY/MM/DD but i want it to appear as DD/MM/YYYY.

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 28, 2003, 4:34pm UTC](https://forum.kirupa.com/t/date-from-mysql-db/29606/2 "2003-08-28T16:34:29Z")

</div>

Set the type to smalltext instead of date and just manually type the date.