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 bug? Is there a work around? My application requires to catch
inter-second events and to maintain their order.
Also what is the SQL standard way to manipulate below sec columns.
Your help is very appreciated. Please reply to me directly (as well).
Gunter Leeb
Output:
mysql> insert MMEReason(ID, Modified, Event_ref) values(-1, '2001-09-26
16:08:09.000001299', -1);
Query OK, 1 row affected (0.00 sec)
mysql> insert MMEReason(ID, Modified, Event_ref) values(-2, '2001-09-26
16:08:09.000001399', -1);
Query OK, 1 row affected (0.00 sec)
mysql> insert MMEReason(ID, Modified, Event_ref) values(-3, '2001-09-26
16:08:09.000001199', -1);
Query OK, 1 row affected (0.00 sec)
mysql> select ID, Modified from MMEReason order by modified;
+----+----------------+
| ID | Modified |
+----+----------------+
| -3 | 20010926160809 |
| -2 | 20010926160809 |
| -1 | 20010926160809 |
+----+----------------+
3 rows in set (0.00 sec)
Environment:
Mysql: V. 3.23.41-max-nt
JDBC MM-mysql. V.2.0.6
recent Microsoft JVM
Win2K
Gunter Leeb
Director of Development
MachineGeneration Inc.
[EMAIL PROTECTED]
Direct: (512) 266 2139
Main: (512) 266 9580
---------------------------------------------------------------------
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
