advice on datetime data type
 

I need some advice on whether I should save unix timestamps in MySQL or should I create a datetime datatype and store it like YYYY-MM-DD HH:MM:SS

I'm trying to go with the most efficient way possible. Should I have php do the math for me or should I have the mysql query do the math for me. Can anyone shine some light on this?

Thanks

I always store Unix Timestamps for my dates/times. :) So I think you should too, cause it's much easier, just a long int. :P

I'm just like Orc storing it as a UNIX TIMESTAMP as an int.

I also prefer to store the timestamp in the database as an int instead of a DATETIME type of field. It's less memory consuming, in the first place, and secondly, you can then format a timestamp how the hell ever you want.