Re: timeofday() and now() issue..

On Friday 02 May 2003 8:27 pm, Tom Lane wrote:
> Rajesh Kumar Mallah <mallah(at)trade-india(dot)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.