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

From Christopher Kings-Lynne
Subject Re: Oddity with extract microseconds?
Date
Msg-id 43963E42.8010408@familyhealth.com.au
Whole thread Raw
In response to Re: Oddity with extract microseconds?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Oddity with extract microseconds?
Re: Oddity with extract microseconds?
List pgsql-hackers
>>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');

Chris



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Concurrent CREATE INDEX, try 2 (was Re: Reducing relation locking overhead)
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Optimizer oddness, possibly compounded in 8.1