Received: from syse.dce.vic.gov.au (syse.nre.vic.gov.au [203.11.140.1]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA21402; Sun, 8 Nov 1998 18:37:29 -0500 (EST) (envelope-from mathera@woody.agvic.gov.au) Received: from sysm.dce.vic.gov.au (sysm.dce.vic.gov.au [157.128.80.81]) by syse.dce.vic.gov.au (8.9.1a/8.9.1) with ESMTP id KAA07111; Mon, 9 Nov 1998 10:34:57 +1100 (EST) Received: from ag-gpo.agvic.gov.au (ag-gpo [157.128.36.36]) by sysm.dce.vic.gov.au with ESMTP id KAA04440 (8.8.5/IDA-1.7); Mon, 9 Nov 1998 10:35:08 +1100 (EST) Received: from woody.agvic.gov.au (woody.agvic.gov.au [157.128.79.21]) by ag-gpo.agvic.gov.au with ESMTP id KAA02227 (8.8.5/IDA-1.7); Mon, 9 Nov 1998 10:38:08 +1100 (EST) Received: from WOODY/SpoolDir by woody.agvic.gov.au (Mercury 1.31); 9 Nov 98 10:34:45 +11:00 Received: from SpoolDir by WOODY (Mercury 1.31); 9 Nov 98 10:34:20 +11:00 Received: from salmon by woody.agvic.gov.au (Mercury 1.31); 9 Nov 98 10:34:16 +11:00 Comments: Authenticated sender is From: "Andrew Mather (Powered By Linux)" Organization: COMPLETE LACK OF To: "W.H. Dekker" Date: Mon, 9 Nov 1998 10:25:52 +0000 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [NOVICE] (Fwd) Hi and some advice on Dates Reply-to: mathera@woody.agvic.gov.au CC: pgsql-novice@postgreSQL.org, pgsql-sql@postgreSQL.org X-Confirm-Reading-To: mathera@woody.agvic.gov.au X-pmrqc: 1 Priority: normal In-reply-to: <199811081036.LAA00206@servaly.hobby.nl> References: <104E3CB13D06@woody.agvic.gov.au> (mathera@woody.agvic.gov.au) X-mailer: Pegasus Mail for Win32 (v2.53/R1) Message-ID: <1060F7470AD4@woody.agvic.gov.au> G'day , Thanks for your reply. > > 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. > Will have a look ! I am using perl for an interface to this db anyway. I didn't realise there was a date module ! Andrew -------------------------------------------------------- Andrew Mather: System Administrator, VIAS mathera@woody.agvic.gov.au / amsm@deakin.edu.au http://www.deakin.edu.au/~amsm/index.html Ph: 03 92174342 (BH), Mob 0413 009 761 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- NEWS! Police begin campaign to run down jaywalkers -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-