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)
===

Bye!

Nhan NGO DINH



Thu, 27 Nov 2003 09:49:22 +0100
Nhan NGO DINH <nngodinh@tiscali.it>
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/

Thu, 27 Nov 2003 10:29:22 +0100
Karel Zak <zakkr@zf.jcu.cz>
Re: timestamp convert function
Karel Zak <zakkr@zf.jcu.cz> writes:
> On Thu, Nov 27, 2003 at 09:49:22AM +0100, Nhan NGO DINH wrote:
>> This output has been obtained from a PostgreSQL 7.3.4

>  I think it's fixed in 7.4.

Yes.  The patch will also be in 7.3.5 when we release that (probably in
the next week or so).

			regards, tom lane

Fri, 28 Nov 2003 11:38:31 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: timestamp convert function 