View Single Post
03-04-2008, 02:09 PM
Join Date: Feb 2008
I agree with the usage of INT for date, and I'm using UNIX TIMESTAMP.
Further I think that tinyint would work fine for smaller blogs however for larger project (that are projected for high input and output trough the database) it is essential to use INT.
Now the date storage has been an issue for me, but I've decided for the UNIX TIMESTAMP but here is also
3 Date and Time types
for that usage: DATETIME, TIME, TIMESTAMP.
is an interesting article how to use phps date function or MySQL Date/Time types for your date storage.
SOCK, thank you on your criticism
Back from sysadmins to the programmers.
View Public Profile
Send a private message to abiko
Visit abiko's homepage!
Find More Posts by abiko