Hi,
have a look at http://www.php.net/manual/en/function.date.php
According to your example, it would be something like:
?php
$date1=date(d M Y H:i, 20020123143547);
?
Regards
Marcus
Ive got a timestamp in a database column and basically
I was wondering if there was any function in PHP to
Oops,
got it all wrong. Thought it was a real timestamp, but it's already
the date, only formatted in a different way.
The date() function expects a Unix-timestamp as its second argument.
Thus you could try to leave the conversion to MySQL by using
UNIX_TIMESTAMP(your_timestamp_column) or if you
I had a set of tables which I exported from Access database.
But now, I want to index these tables. How do I go about that?
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
mysql ALTER TABLE your_table ADD KEY(your_column);
Hope that helps
Marcus