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 that will automatically handle the time values you're looking for. You'll have to generate them in your application. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 20 days, processed 394,201,857 queries (217/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
