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?
"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 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.
I have optimistic thoughts, even though sometimes (if not always) life's a bitch.