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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to