Postgres Pro
Downloads
Home   >   mailing lists

timestamp convert function - Mailing list pgsql-hackers

From Nhan NGO DINH
Subject timestamp convert function
Date
Msg-id 6.0.0.22.2.20031127093319.01d03e68@192.168.0.254
Whole thread Raw
Responses Re: timestamp convert function
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Jonathan Gardner
Date:
Subject: Viewing Parse Tree of a query from front end
Next
From: Peter Eisentraut
Date:
Subject: Re: Viewing Parse Tree of a query from front end