timestamp vs. datetime

[Anon]

which of this two type of date is better to used in php programs (mysql D😎 ??? And how can i split day,month,year and time from a datetime field ???

[[deleted]]

1. datetime, because timestamp is auto-updating

2. rtfm http://www.mysql.com/doc/D/a/Date_and_time_functions.html