Postgres Pro
Downloads
Home   >   mailing lists

Thread: timestamp convert function

timestamp convert function

From
Nhan NGO DINH
Date:
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

Re: timestamp convert function

From
Karel Zak
Date:
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/

Re: timestamp convert function

From
Tom Lane
Date:
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