Thanks man that really helps but i am still confused, according to that manual TIMESTAMP is the one to be used so that MySQL automatically sets Date and time. Now then DATETIME isn't set by MySQL per se but it is set by a query by PHP let's say.
This leaves me with the doubt of which one to use. I would fall towards Datetime because i don't want the datetime update at any update queries and only on the first INSERT query. But i would also like my own datetime format...
Any suggestions? Should i just make a varchar field and then insert a string like the following
This would be my preferred way to store it, but i am afraid that it would become difficult later on to compare dates...is that so?
Thanks for the help even if i don't say so in the end so that i don't *bump* the post up.