| From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
|---|---|
| To: | Ramanika <ramanika(at)flashmail(dot)com> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] datetime sample code? |
| Date: | 1999-08-04 09:22:53 |
| Message-ID: | l03130300b3cdb62d5bcc@[147.233.159.109] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
At 04:36 +0300 on 04/08/1999, Ramanika wrote:
> I am looking for sample datetime functions but could not find them in
> the manuals.
> I want to get the current datetime from the system and insert into a
> table.
>
> I want to select out parts of datetime like hours only or time only or
> date only. I know this must be possible I just need some examples.
Look in the PostgreSQL user guide, page 41 (It's in chapter 5, functions).
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Howie | 1999-08-04 11:08:30 | Re: [SQL] referential integrity |
| Previous Message | Stéphane FILLON | 1999-08-04 03:21:57 | Cache lookup failed with FUNCTION + TRIGGER |