View Single Post
Old 07-25-2008, 07:30 PM   #1 (permalink)
webosb
The Contributor
 
webosb's Avatar
 
Join Date: Nov 2007
Posts: 41
Thanks: 24
webosb is on a distinguished road
Default 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
__________________
"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
webosb is offline  
Reply With Quote