Horton

Antw: [SQL]

Gerhard Dieringer <dieringg@eba-haus.de>

View thread View on postgr.es
From: "Gerhard Dieringer" <DieringG@eba-haus.de>
To: <pgsql-novice@postgresql.org>, <gomathi_raju@usa.net>
Date: 2000-05-25T06:48:08Z
Lists: pgsql-novice 
gomathi raju wrote:

> I want to get the system timestamp from postgresql database.
> But I dont have a dual table from where ,I can select it.
> Give me a solution, from which table(system) I can get it.

Unlike Oracle, you don't need a from clause in postgreSQL.
You can just say

    select some_expression;

without from dual

Gerhard