# Date and Time formatting

**URL:** <https://forum.kirupa.com/t/date-and-time-formatting/283598>\
**Category:** programming\
**Created:** [March 9, 2009, 12:43am UTC](https://forum.kirupa.com/t/date-and-time-formatting/283598 "2009-03-09T00:43:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pherank](https://avatars.discourse-cdn.com/v4/letter/p/4af34b/32.png) [@Pherank](https://forum.kirupa.com/u/Pherank)\
**Post date:** [March 9, 2009, 12:43am UTC](https://forum.kirupa.com/t/date-and-time-formatting/283598/1 "2009-03-09T00:43:42Z")

</div>

If I use the following code to place data in a MySQL database field, what kind of field type do I need to use to preserve the formatting?

```auto
$mysqldate = date('m-d-Y H:i:s');

```