Re: [SQL] query for records based on date

2005-02-21 Thread Martín Marqués
El Lun 21 Feb 2005 17:00, Brandon Metcalf escribió: > If I have a table with an attribute of type "timestamp without time > zone", what is the best way to query that table for records that are > older than, say, one week. > > I suppose I could get the current time in epoch seconds and the time of >

Re: [SQL] query for records based on date

2005-02-21 Thread Brandon Metcalf
m == martin@bugs.unl.edu.ar writes: m> El Lun 21 Feb 2005 17:00, Brandon Metcalf escribió: m> > If I have a table with an attribute of type "timestamp without time m> > zone", what is the best way to query that table for records that are m> > older than, say, one week. m> > m> > I suppose I

Re: [SQL] query for records based on date

2005-02-21 Thread Richard Huxton
Brandon Metcalf wrote: If I have a table with an attribute of type "timestamp without time zone", what is the best way to query that table for records that are older than, say, one week. I suppose I could get the current time in epoch seconds and the time of the attribute in the same, and select th

[SQL] query for records based on date

2005-02-21 Thread Brandon Metcalf
If I have a table with an attribute of type "timestamp without time zone", what is the best way to query that table for records that are older than, say, one week. I suppose I could get the current time in epoch seconds and the time of the attribute in the same, and select those records where the