BennieC Posted January 15, 2010 Share Posted January 15, 2010 Hi, I am confused about the format of the datetime and timestamp fields. Are these in ASCII or numeric? As the locale settings on computers differ, is there a way to get past the formatting automatically or should you preformat before storing in such a field. Would it not be better to store in a Real format as used by the development language? I use MySQL 5.1.39 and Delphi on BDS2010 for development. (I hope I have adhered to the enough rules as the threat seems ominous http://www.phpfreaks.com/forums/Smileys/nrg_alpha/wink-02.gif- I have just joined this forum) Quote Link to comment https://forums.phpfreaks.com/topic/188550-datetime-format/ Share on other sites More sharing options...
fenway Posted January 16, 2010 Share Posted January 16, 2010 Let the DB worry about how to store these -- use datetime if you want a absolute date/time, timestamp if you want it to be timezone-aware. Otherwise, you can display it how ever you'd likeon the way out. Quote Link to comment https://forums.phpfreaks.com/topic/188550-datetime-format/#findComment-995959 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.