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