DateTime format

[BennieC]

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)

[fenway]

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.