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

Christopher Kings-Lynne wrote:

>>> Why aren't 'minutes' considered too?  Because they aren't 'seconds'. 
>>> Well, seconds aren't microseconds either.
>>
>>
>> Yeah, they are: it's just one field.  The other way of looking at it
>> (that everything is seconds) is served by "extract(epoch)".
>
>
> Well, it's different in MySQL unfortunately - what does the standard 
> say?  Out of interest, can someone try this for me in MySQL 5:
>
> SELECT EXTRACT (MICROSECOND FROM '2003-01-02 10:30:00.00123');
> SELECT EXTRACT (MICROSECOND FROM '2003-01-02 10:30:10.00123');


mysql 4.1.5 gives back 123 in both cases. I assume they haven't changed 
that, although anything is possible.

cheers

andrew