Re: Oddity with extract microseconds? - Mailing list pgsql-hackers

> 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