On Thu, 12 Oct 2000, Jean-Christophe Boggio wrote:
> portion of the day (although I don't know --yet-- how to convert
> date2-date1 to an integer, trunc does not work).
reltime(date2-date1)::int
Will subtract date1 from date2, then cast it to an integer.
John
Hey, there,
This is very interesting.
I have similar problem:
I want drop some junky table in my database, how can I detect a table when last
time it is used.
I try to say that I want to know how long this table has NOT been used at all.
I don't which system table holds this statistics.
Josh Be
Brian, Jean-Christophe,
>Someone corrects me if I'm wrong, I come from the Oracle world...
>
> Dates (or I should say TimeStamps) are stored as floating point values
> : the integer part is the number of days since a certain date
> (epoch or 01/01/1970 on unix-based databases) and the fractionna
hi Brian,
BCD> I need to write a query that will pull information from table2 if
BCD> information in table1 is older then xdate.
BCD> My laymen example:
BCD> SELECT table2.date, count(table2.name) as count
BCD> WHERE table1.startdate > 2 weeks
BCD> AND table2.submitdate > 2 weeks
BCD> ;
BCD>
Hello all,
I need to write a query that will pull information from table2 if
information in table1 is older then xdate.
My laymen example:
SELECT table2.date, count(table2.name) as count
WHERE table1.startdate > 2 weeks
AND table2.submitdate > 2 weeks
;
So i Guess my real questions is how do
