Converting a timestamp to date()

[Anon]

Can anyone help me with a code to convert a unix timestamp using the date() function or getdate() function to a time & date.
My unix timestamps looks like this:097874326234 & I want to convert it to Thursday 20th March, 2001 time- 14.34 ....etc
Many Thanks

[jjoske]

You could use the MySql commands to it.
ie
SELECT DAYNAME(date) AS dayname, DAYOFMONTH(date) AS day, MONTHNAME(date) AS month YEAR(date) AS YEAR FROM table

[[deleted]]

That would be a good answer if the question was anywhere near database-related.

In PHP just use date(), rtm.