timestamp or date for php.

[kennyTE]

Hello,
i'm designing a databases structure, i need expert to advise me. Let say, i'm keeping a time to record a certain action, what "data type" i should use to keep the time? As i know there is 2 way to keep time in MySQL, 1st is "Timestamp", 2rd is "Date". Which is suitable? PLS, someone advise me.

Thanks.

[bubbisthedog]

The DATE data type does not include a time. If you need to store the time, research the TIME and DATETIME data types.