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

__________________
"Things you can get access to, you should never memorize." -Albert Einstein
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

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

__________________
VillageIdiot can have my babbies ;d

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.

__________________