On Mon, Jun 30, 2036 at 10:05:43PM -0600, gomathi raju wrote:
> Hi friends,
>
> 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.
Could this be what you want?
template1=# select CURRENT_TIMESTAMP;
timestamp
------------------------
2000-05-24 23:40:19+01
Cheers,
Patrick