Re: timeofday() and now() issue.. - Mailing list pgsql-sql

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