From: | "Andrew Mather (Powered By Linux)" <mathera(at)woody(dot)agvic(dot)gov(dot)au> |
---|---|
To: | pgsql-novice(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org |
Subject: | (Fwd) Hi and some advice on Dates |
Date: | 1998-11-08 15:41:49 |
Message-ID: | 104E3CB13D06@woody.agvic.gov.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
G'day All,
I am pretty new to postgres and am using it as a backend for DB's
accessed via the web and Perl DBI. All this works really well and I
have a few db's up and running on our Intranet at work, where they're
quite heavily used.
My current project requires me to do some date calculations and I'm
stumped !
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 ?)
I've searched the archives without success and the doc's don't give
much away as far as this type of thing goes.
Thanks in anticipation.
Andrew
--------------------------------------------------------
Andrew Mather: System Administrator, VIAS
mathera(at)woody(dot)agvic(dot)gov(dot)au / amsm(at)deakin(dot)edu(dot)au
http://www.deakin.edu.au/~amsm/index.html
Ph: 03 92174342 (BH), Mob 0413 009 761
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Linux: it's not just for breakfast anymore.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-
From | Date | Subject | |
---|---|---|---|
Next Message | David Jackson | 1998-11-08 16:59:17 | Foreign Key ?? |
Previous Message | Herouth Maoz | 1998-11-08 12:12:28 | Re: [SQL] newline in text field |