From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: timeofday() and now() issue..
Date: Fri, 2 May 2003 20:37:09 +0530
Message-ID: <200305022037.09625.mallah@trade-india.com> (raw)
In-Reply-To: <10505.1051887437@sss.pgh.pa.us>
References: <200305021844.35194.mallah@trade-india.com>
<10505.1051887437@sss.pgh.pa.us>
On Friday 02 May 2003 8:27 pm, Tom Lane wrote:
> Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> > SELECT CAST (timeofday() as timestamp with time zone) - CAST (now() as
> > timestamp with time zone); shudn't it return something close to 0 ?
>
> Works for me ... what's your platform, PG version, and timezone?
> And what are you getting from the intermediate steps in that expression?
>
> regards, tom lane
Dunno if details given below would suffice,
please lemme know if you want anything specific
Regds
mallah.
tradein_clients=# SELECT version();
+-------------------------------------------------------------+
| version |
+-------------------------------------------------------------+
| PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96 |
+-------------------------------------------------------------+
(1 row)
Time: 2183.62 ms
tradein_clients=# SELECT CAST (timeofday() as timestamp with time zone) ;
+----------------------------------+
| timeofday |
+----------------------------------+
| 2003-05-03 00:02:25.386096+05:30 |
+----------------------------------+
(1 row)
Time: 2537.58 ms
tradein_clients=#
tradein_clients=# SELECT CAST ( now() as timestamp with time zone) ;
+----------------------------------+
| now |
+----------------------------------+
| 2003-05-02 20:32:34.564175+05:30 |
+----------------------------------+
(1 row)
Time: 673.78 ms
tradein_clients=# SELECT timeofday();
+-------------------------------------+
| timeofday |
+-------------------------------------+
| Fri May 02 20:34:13.634355 2003 IST |
+-------------------------------------+
(1 row)
Time: 647.73 ms
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us
Subject: Re: timeofday() and now() issue..
In-Reply-To: <200305022037.09625.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox