Received: from hgatenl.hobby.nl (root@hgatenl.hobby.nl [212.19.199.2]) by hub.org (8.9.1/8.9.1) with ESMTP id QAA10641; Sun, 8 Nov 1998 16:27:10 -0500 (EST) (envelope-from wybo@servaly.hobby.nl) Received: (from Sservaly@localhost) by hgatenl.hobby.nl (8.8.8/8.8.8) with UUCP id WAA21648; Sun, 8 Nov 1998 22:18:10 +0100 (CET) X-Authentication-Warning: hgatenl.hobby.nl: Sservaly set sender to wybo@servaly.hobby.nl using -f Received: (from wybo@localhost) by servaly.hobby.nl (8.8.8/8.8.5) id LAA00206; Sun, 8 Nov 1998 11:36:47 +0100 Date: Sun, 8 Nov 1998 11:36:47 +0100 Message-Id: <199811081036.LAA00206@servaly.hobby.nl> From: "W.H. Dekker" To: mathera@woody.agvic.gov.au CC: pgsql-novice@postgreSQL.org, pgsql-sql@postgreSQL.org In-reply-to: <104E3CB13D06@woody.agvic.gov.au> (mathera@woody.agvic.gov.au) Subject: Re: [NOVICE] (Fwd) Hi and some advice on Dates 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@servaly.hobby.nl | 4158 CH Deil, The Netherlands | fax +31-345-652383