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