Monday, June 18, 2007

MySQL - No Millisecond-Precision Date/Time

I guess I've been spoiled not doing anything particularly serious in MySQL thus far; I'm only just now discovering that it doesn't support millisecond-precision date-time datatypes directly. Fascinating.

Not a big deal most of the time, but for some precise date-comparison routines, we've used this capability before, in Oracle, and in other databases, so I'm just a little surprised.

1 comment:

Basil said...

I'm not surprised. The product came out of a very narrow need for fast reading of certain kinds of data. Anything that didn't fit those needs seems to have been an afterthought.

Don't get me wrong, I'm happy to have choice in the opensource database market; but I don't think I'd choose MySQL when others like Postgres are out there that are less limiting.