| From: | Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au> |
|---|---|
| To: | gomathi raju <gomathi_raju(at)usa(dot)net> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] |
| Date: | 2000-05-25 00:02:37 |
| Message-ID: | 392C6D9D.C53C104B@nimrod.itg.telecom.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-novice pgsql-sql |
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.
Are you talking about
SELECT 'now'
?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2000-05-25 03:49:56 | Good article on linux.com about PostgreSQL (sortof). |
| Previous Message | Chris Bitmead | 2000-05-25 00:00:11 | [Fwd: 97BA-B931-B61D : CONSULT from pgsql-hackers-oo (post) (fwd)] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael A. Mayo | 2000-05-25 04:54:38 | Re: [SQL] |
| Previous Message | Andre Majorel | 2000-05-24 23:01:34 | Re: Compiling the JDBC interface - make fails |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-05-25 02:59:58 | Re: possible bug with group by? |
| Previous Message | Joseph Shraibman | 2000-05-24 23:21:35 | Re: possible bug with group by? |