I have a history file and I would like to sequence it in date time sequnce. However, I need more precision than a second. I have looked at the docs but thought I would float the question out here:
What is the best way to store dates with micro or milli second precision?
And, is there a noticeable performance hit when using such a thing?
Many thanks for any help,
my question to you is, where are the times containing microseconds going to be coming from?
Well, I imagine there can be either a php function or a MySQL routine. I was hoping to be pointed in the right direction.
Unless, of course, MySQL does not have a data type that can store fractions of seconds. If that is the case, and I wonder if it is, then I will have to put in place another mechanism that allows me to store and then retrieve highly precise chronological data.
Any assistance much appreciated,
wonder no more
you could use DECIMAL to make your own, i guess
which leads back to... where are these fractional values going to be coming from?
This topic is now archived. It is frozen and cannot be changed in any way.