| From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | gomathi raju <gomathi_raju(at)usa(dot)net> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] |
| Date: | 2000-05-24 22:40:57 |
| Message-ID: | 20000524234057.A22396@quartz.newn.cam.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-05-24 23:00:53 | Re: understanding Datum -> char * -> Datum conversions |
| Previous Message | Brook Milligan | 2000-05-24 22:29:22 | Re: understanding Datum -> char * -> Datum conversions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Majorel | 2000-05-24 23:01:34 | Re: Compiling the JDBC interface - make fails |
| Previous Message | Travis Ruthenburg | 2000-05-24 19:48:51 | Re: Setting Defaults |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyle Bateman | 2000-05-24 22:44:44 | Clarified Question |
| Previous Message | Joseph Shraibman | 2000-05-24 22:30:49 | possible bug with group by? |