eazygen — 2012-01-17T06:33:16-05:00 — #1
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,
r937 — 2012-01-17T09:02:39-05:00 — #2
my question to you is, where are the times containing microseconds going to be coming from?
eazygen — 2012-01-17T09:28:29-05:00 — #3
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,
r937 — 2012-01-17T10:05:00-05:00 — #4
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?