Hello everybody,

Firstly, I have a datetime field in mySQL database and I want to insert system datetime whenever record is inserted into the table. If I use time() function, it returns something "1142866431". I need to save it in such a way that I can track the minutes and hour.

Secondly, I need to get all records from the same table that are past 24 hours or more.

Thanks.