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.