Re: Oddity with extract microseconds?

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