OK, AndrewSN just pointed out that it's "documented" to work like that...
...still seems bizarre...
Chris
Christopher Kings-Lynne wrote:
Does anyone else find this odd:
mysql=# select extract(microseconds from timestamp '2005-01-01
00:00:00.123');
date_part
-----------
123000
(1 row)
mysql=# select extract(microseconds from timestamp '2005-01-01
00:00:01.123');
date_part
-----------
1123000
(1 row)
No other extracts include other fields. eg, minutes:
mysql=# select extract(minutes from timestamp '2005-01-01 00:10:00');
date_part
-----------
10
(1 row)
mysql=# select extract(minutes from timestamp '2005-01-01 10:10:00');
date_part
-----------
10
So how come microseconds includes the microseconds from the 'seconds'
field and not just after the '.'? And if it's supposed to include
'seconds', then why doesn't it include minutes, hours, etc.?
Chris
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
