Inserting Dates, and Gettign Dates from Mysql

[Maleko]

Ok, at the moment, The way Im inserting my date into m db is:

$date = Date("y-m-d h:i:s");
		$query="INSERT INTO tablename (name,email,url,message,dateadded) VALUES
			('$name','$email','$url','$message','$date')";

and to get it out:

$select = mysql_query("SELECT name,email,url,message,DATE_FORMAT(dateadded, '%b-%D-%Y, %h:%i:%s %p')dateadded FROM tablename ORDER BY id DESC", $connection)

The weird thing is, I tested it, at 7:03 pm my time, and the server responded with 08:03 am.....the server is in the same country as me etc...

Any ideas into this? any better ways of inserting the date? cheers!

[LordShryku]

What kind of column is your date being stored in? That format isn't normal for any sort of storage (the two digit year and 12 hour format especially)

[Maleko]

stored as datetime