# Date()

**URL:** <https://forum.kirupa.com/t/date/261540>\
**Category:** Uncategorized\
**Created:** [May 28, 2008, 5:28pm UTC](https://forum.kirupa.com/t/date/261540 "2008-05-28T17:28:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NeoDreamer](https://avatars.discourse-cdn.com/v4/letter/n/ccd318/32.png) [@NeoDreamer](https://forum.kirupa.com/u/NeoDreamer)\
**Post date:** [May 28, 2008, 5:28pm UTC](https://forum.kirupa.com/t/date/261540/1 "2008-05-28T17:28:13Z")

</div>

In my MySQL table, I have a timestamp column with values like “2008-05-28 00:39:40”. First, I must remove all the formatting:

```php

$delimeters = array('-', ' ', ':');
$time = str_replace($delimeters, '', $new['time']);
echo $time;
// 20080528003940 is displayed

```

Then I attempt to use the date function on this, but it gives me a weird date in the future:

```php

echo date('M, j, Y', $time);
// Jan, 19, 2038 is displayed

```

---

<div class="post-metadata">

**Author:** ![krilnon](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/krilnon/32/34_2.png) [@krilnon](https://forum.kirupa.com/u/krilnon)\
**Post date:** [May 28, 2008, 6:06pm UTC](https://forum.kirupa.com/t/date/261540/2 "2008-05-28T18:06:17Z")

</div>

The second parameter is interpreted as the number of seconds since the Unix epoch, I think.

You could use _strtotime_:

```php
$str = "2008-05-28 00:39:40";
echo date('M, j, Y', strtotime($str));

```

---

<div class="post-metadata">

**Author:** ![djheru](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/djheru/32/3190_2.png) [@djheru](https://forum.kirupa.com/u/djheru)\
**Post date:** [May 28, 2008, 6:14pm UTC](https://forum.kirupa.com/t/date/261540/3 "2008-05-28T18:14:22Z")

</div>

You need to use php’s strtotime to convert the mysql time to unix time.

```php

$time = strtotime($new['time'];
echo date('M, j, Y', $time);

```

---

<div class="post-metadata">

**Author:** ![NeoDreamer](https://avatars.discourse-cdn.com/v4/letter/n/ccd318/32.png) [@NeoDreamer](https://forum.kirupa.com/u/NeoDreamer)\
**Post date:** [May 28, 2008, 6:26pm UTC](https://forum.kirupa.com/t/date/261540/4 "2008-05-28T18:26:12Z")

</div>

Yup, that does the trick. Thanks.