Thread: Sysdate counterpart in postgres

Sysdate counterpart in postgres

From
Manish Vig
Date:
Dear Sir,
I wish to know whether nested and Co-related Query are possible on Postgres.

What is the counterpart for
"Sysdate from dual " in postgres.
with best Reagrds
Manish Vig


Re: Sysdate counterpart in postgres

From
Anand Raman
Date:
On Wed, Nov 29, 2000 at 08:39:38PM +0000, Manish Vig wrote:
>Dear Sir,
>I wish to know whether nested and Co-related Query are possible on Postgres.
yes they are allowed
>
>What is the counterpart for
>"Sysdate from dual " in postgres.
select current_time;

>with best Reagrds
>Manish Vig
Hope this helps
Anand Raman