I created a table that has info on updates to a section of my website. I want the date & time to be above the update text. Here is the SQL of the table
CREATE TABLE songlist_updates (
songlist_updates_id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY (songlist_updates_id)
The problem i am having is getting the timestamp in a usable form. All the functions in the manual i looked at dealt with manipulating the timestamp using the date() or time() functions when inserting the data but not extracting it from the database.
Here is a row in the database
INSERT INTO songlist_updates VALUES ( '4', 'Added info to Do Right.', '19990728120000');
--What i want is for the top line to say
Added on July 28, 1999 at 12:00
--then the next line to say
Added info to Do Right.
So i can't figure out to use built in functions to get '19990728120000' into July 28, 1999 at 12:00
Any help would be much appreciated!