View Single Post
Old 01-11-2011, 06:31 AM  
Traxman
Registered User
 
Industry Role:
Join Date: Dec 2010
Location: Close to internet
Posts: 58
Quote:
Originally Posted by andrew.r View Post
We always store php timestamp to the database, can then display it how you want using php date function
Agree, DATE storage is 3 bytes, TIME is 3 aswell, and DATETIME is 8 and an INT is 4 bytes so using one more byte for knowing the exact second is best of all, and doing some extra programming for converting the seconds to whatever you want is worth it.

Down the line, i mean ;)
__________________
Just because I know a lot of things, dont mean I know everything
Traxman is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote