Forums

PHP

This topic is locked

Converting Unix Style date to regular looking date

Posted 10 Nov 2003 17:28:23
1
has voted
10 Nov 2003 17:28:23 Adam Bell posted:
I recently took over a website with a MySQL database already in place. In it, it uses a 'unix_date' category to create dates like '1068938100' and that's the only date object I have available.

Obviously, that won't look good on an online calendar. Noone will understand it.

So how can I use MX to possibly convert it over to something better looking like November 10, 2003 or just 11/10 for example? Is that possible?

Replies

Replied 11 Nov 2003 00:11:09
11 Nov 2003 00:11:09 Phil Shevlin replied:
Try here:
www.mysql.com/doc/en/Date_and_time_functions.html

I think its from_unixtime

Reply to this topic