Re: timestamp convert function

On Thu, Nov 27, 2003 at 09:49:22AM +0100, Nhan NGO DINH wrote:
> Hi,
> 
> This is really not a problem, may be in other circumstances...
> This output has been obtained from a PostgreSQL 7.3.4
> 
> ===
> testdb=# select to_timestamp('23:20:30.123456', 'HH24:MI:SS.US')::time;
>   to_timestamp
> -----------------
>  23:20:30.123459
> (1 row)
> 
> testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time;
>  to_timestamp
> --------------
>  23:20:30
> (1 row)
> 
> testdb=# select to_timestamp('23:20:30', 'HH24:MI:SS.US')::time;
>   to_timestamp
> -----------------
>  23:20:30.123459
> (1 row)
I think it's fixed in 7.4.
   Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/