Creating A Timer

[Sharif]

In the mysql table, a field titled time (type timestamp) which holds a timestamp of when the user last logged in. How would I create something that would allow me to display: Last logged in on MONTH/DAY/YEAR At HOUR:MINUTE:SECOND AM/PM.

[nemonoman]

http://www.mysql.com/doc/en/Date_and_time_functions.html

DATE_FORMAT(date,format)
Formats the date value according to the format string. The following specifiers may be used in the format string....