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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: timeofday() and now() issue..
Date: 2003-05-02 14:57:17
Message-ID: 10505.1051887437@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-05-02 15:07:09 Re: timeofday() and now() issue..
Previous Message Rod Taylor 2003-05-02 14:32:52 Re: What is bad in this query ?