Skip site navigation (1) Skip section navigation (2)

Antw: [SQL]

From: "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>, <gomathi_raju(at)usa(dot)net>
Subject: Antw: [SQL]
Date: 2000-05-25 06:48:08
Message-ID: s92ce8e7.056@kopo001 (view raw, whole thread or download thread mbox)
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


pgsql-novice by date

Next:From: Javier CastroDate: 2000-05-25 10:27:50
Subject: hello
Previous:From: Michael A. MayoDate: 2000-05-25 04:54:38
Subject: Re: [SQL]

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group