SELECT CAST (timeofday() as timestamp with time zone) - CAST (now() as timestamp with time zone);
+-----------------+
| ?column? |
+-----------------+
| 03:30:00.000295 |
+-----------------+
shudn't it return something close to 0 ?
like
SELECT CAST (timeofday() as timestamp ) - CAST (now() as timestamp with time zone);
+-----------------+
| ?column? |
+-----------------+
| 00:00:00.000405 |
+-----------------+
regds
Mallah
--
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.