Hi Guys,
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,
S
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,
S
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?