On Wed, Dec 07, 2005 at 10:47:45AM +0800, Christopher Kings-Lynne wrote: > Ok, and what does this give: > > SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:01.00123');
mysql> SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:01.00123'); +-------------------------------------------------------+ | EXTRACT(MICROSECOND FROM '2003-01-02 10:30:01.00123') | +-------------------------------------------------------+ | 1230 | +-------------------------------------------------------+ 1 row in set (0.00 sec) Does contrary behavior from MySQL count as evidence that PostgreSQL's behavior is correct? :-) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend