Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> OK, AndrewSN just pointed out that it's "documented" to work like that...
> ...still seems bizarre...
It seems reasonably consistent to me. extract() doesn't consider
seconds and fractional seconds to be distinct fields: it's all one
value. The milliseconds and microseconds options just shift the
decimal place for you.
regards, tom lane