From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Oddity with extract microseconds? |
Date: | 2005-12-06 15:39:44 |
Message-ID: | 4395B0C0.1000607@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2005-12-06 15:42:53 | Re: [PATCHES] snprintf() argument reordering not working |
Previous Message | Andrew Dunstan | 2005-12-06 15:38:11 | Re: [PATCHES] snprintf() argument reordering not working |