Critical TIMESTAMP issue?

2001-09-26 Thread Gunter Leeb
Hi everyone, TIMESTAMP types are supposed to contain millis and even nonos. How can I ensure these are set, retrieved and used for ORDER BY and comparisons in MySQL? I cannot find a way to get even millis back. Also MySQL does not seem to order by this information. See below example. Is this a

Re: Critical TIMESTAMP issue?

2001-09-26 Thread Jeremy Zawodny
On Wed, Sep 26, 2001 at 04:53:18PM -0500, Gunter Leeb wrote: Hi everyone, TIMESTAMP types are supposed to contain millis and even nonos. Not according to the documentation. How can I ensure these are set, retrieved and used for ORDER BY and comparisons in MySQL? There is no built-in type