| From: | "W(dot)H(dot) Dekker" <wybo(at)servaly(dot)hobby(dot)nl> |
|---|---|
| To: | mathera(at)woody(dot)agvic(dot)gov(dot)au |
| Cc: | pgsql-novice(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [NOVICE] (Fwd) Hi and some advice on Dates |
| Date: | 1998-11-08 10:36:47 |
| Message-ID: | 199811081036.LAA00206@servaly.hobby.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Andrew Mather wrote:
> Could anyone help with the following: (I have not fixed data type yet,
> I will be guided by any info I can get)
>
> How to query a table and look for any records where
> the value in a date field is greater than (say) 10 days ago
>
> Calculate the difference between two times on the same day. (I have
> experimented with age() and it sort of does wht I want..is there any
> other way ?)
Use Perl as a database interface and have a look at de Perl module
Date::Manip. It has all you need, and more.
--
Best regards,
Wybo
===================Servalys Analytical Chemistry Services=================
Wybo H. Dekker | Deilsedijk 60 | tel +31-345-652164
wybo(at)servaly(dot)hobby(dot)nl | 4158 CH Deil, The Netherlands | fax +31-345-652383
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergei M. Suntsov | 1998-11-08 11:50:51 | newline in text field |
| Previous Message | Ulf Mehlig | 1998-11-08 09:22:04 | Re: [SQL] (Fwd) Hi and some advice on Dates |