Thread: advice on datetime data type
View Single Post
Old 07-28-2008, 04:31 AM   #2 (permalink)
Orc
The Prestige
 
Orc's Avatar
 
Join Date: Dec 2007
Location: On your Hard Drive, hiding like a Virus
Posts: 888
Thanks: 168
Orc is on a distinguished road
Default
Quote:
Originally Posted by webosb View Post
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
__________________
Wax on, Wax off
Orc is offline   		Reply With Quote