TalkPHP - View Single Post

abiko · 03-04-2008, 02:09 PM

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.
Here 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

03-04-2008, 02:09 PM	#9 (permalink)
abiko The Contributor Join Date: Feb 2008 Location: Croatia Posts: 90 Thanks: 4	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. Here 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.