How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?

From: "Liang Luo" <liang(dot)luo(at)convergia(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
Date: 2003-03-25 14:38:40
Message-ID: 00e401c2f2dc$3aa87280$e6071cac@convergia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


This is the query and result:

select h323_setup_time from pv_legs_new where h323_setup_time = '2003-01-01
00:43:59.996-05';

h323_setup_time
---------------------------
2003-01-01 00:43:60.00-05

Actually, the real data of second and millisecond is 59.996-05, but it shows
60.00. I failed to load it when I use this result in other query.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ryan 2003-03-25 14:50:28 Re: column label
Previous Message Antti Haapala 2003-03-24 18:36:31 Re: function with security definer