sergramalli Posted June 30, 2013 Share Posted June 30, 2013 can just say i am all mixed up about dates and mysql. in a database should i store in an 7/12/13 format or with as a Unix Timestamp (epoch i think). so what is the best way to store dates into a database and convert back to human readable or should i make it human readable in the database If also someone could point me the right direction of a tutorial or book or something that would be good too Link to comment https://forums.phpfreaks.com/topic/279715-dates-functions/ Share on other sites More sharing options...
Barand Posted June 30, 2013 Share Posted June 30, 2013 Store them as DATE, DATETIME or TIMESTAMP types. Formats are YYYY-MM-DD HH:ii:ss for datetime and timestamp and YYYY-MM-DD for date type Using these types will give maximum functionality (usable by the date/time functions in MySql and can be easily sorted/compared) Link to comment https://forums.phpfreaks.com/topic/279715-dates-functions/#findComment-1438660 Share on other sites More sharing options...
sergramalli Posted June 30, 2013 Author Share Posted June 30, 2013 oh ok, seems like your saying either way...right?Thank you for answering my question Link to comment https://forums.phpfreaks.com/topic/279715-dates-functions/#findComment-1438689 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.