![]() |
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. |