MySQL 5.0.16 gives an error: mysql> SELECT EXTRACT (MICROSECOND FROM '2003-01-02 10:30:00.00123'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM '2003-01-02 10:30:00.00123')' at line 1
Odd, that example is straight from the MySQL 5 manual: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Chris ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
