CodeIgniter Forums
How Should I Store Dates in MySQL? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: How Should I Store Dates in MySQL? (/showthread.php?tid=46566)



How Should I Store Dates in MySQL? - El Forum - 11-07-2011

[eluser]TerryT[/eluser]
I am using JQuery's datapicker for users to pick the date of an item on my forms. My question is what is best practice for the format for storing dates in a mySQL table from a Codeigniter app?

I will be using the dates to determine items within the last 7 days and printing them on reports in dd/mm/yy format. Thanks.