Re: [NOVICE] (Fwd) Hi and some advice on Dates
От | Andrew Mather (Powered By Linux) |
---|---|
Тема | Re: [NOVICE] (Fwd) Hi and some advice on Dates |
Дата | |
Msg-id | 1060F7470AD4@woody.agvic.gov.au обсуждение исходный текст |
Ответ на | Re: [NOVICE] (Fwd) Hi and some advice on Dates ("W.H. Dekker" <wybo@servaly.hobby.nl>) |
Список | pgsql-sql |
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-
В списке pgsql-sql по дате отправления: