Best format to save date?

Best format to save date?

El Forum
Guest

05-04-2009, 05:18 AM

[eluser]clintonbeattie[/eluser]
Hi,

I'm building a simple blog and was wondering, what is the best format to save date data to the database?

I will be sorting dates so I can have an Archive or blog entries and the users' comments will be dated also.

DATE, DATETIME or TIMESTAMP?

Read this, but still don't know which is best for my situation...http://www.bigroom.co.uk/blog/dates-in-php-and-mysql

Thanks for the advice.
C

Messages In This Thread

Best format to save date? - by El Forum - 05-04-2009, 05:18 AM

Best format to save date? - by El Forum - 05-04-2009, 05:35 AM

Best format to save date? - by El Forum - 05-04-2009, 05:38 AM

Best format to save date? - by El Forum - 05-04-2009, 05:58 AM

Best format to save date? - by El Forum - 05-04-2009, 12:07 PM

Best format to save date? - by El Forum - 05-04-2009, 12:57 PM

Best format to save date? - by El Forum - 05-04-2009, 06:57 PM

Best format to save date? - by El Forum - 05-04-2009, 11:28 PM

Best format to save date? - by El Forum - 05-04-2009, 11:31 PM

Best format to save date? - by El Forum - 05-05-2009, 02:37 AM

Best format to save date? - by El Forum - 05-05-2009, 02:46 AM

Best format to save date? - by El Forum - 05-05-2009, 03:13 AM

Best format to save date? - by El Forum - 05-06-2009, 04:04 PM

Best format to save date? - by El Forum - 05-06-2009, 04:37 PM

Best format to save date? - by El Forum - 05-06-2009, 06:07 PM

Best format to save date? - by El Forum - 05-06-2009, 06:17 PM

Best format to save date? - by El Forum - 05-06-2009, 06:21 PM

Best format to save date? - by El Forum - 05-06-2009, 06:30 PM

Best format to save date? - by El Forum - 05-06-2009, 07:55 PM

Best format to save date? - by El Forum - 05-22-2009, 10:20 PM