> Looks like MySQL doesn't allow a space before the open parenthesis
> (there isn't one in the manual's example):
>
> mysql> SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123');
> +-------------------------------------------------------+
> | EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123') |
> +-------------------------------------------------------+
> | 1230 |
> +-------------------------------------------------------+
> 1 row in set (0.01 sec)
Ok, and what does this give:
SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:01.00123');
Chris