| From: | "Joel Burton" <joel(at)joelburton(dot)com> |
|---|---|
| To: | "Andrew Bartley" <abartley(at)evolvosystems(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: time in 7.2 |
| Date: | 2002-05-13 17:47:03 |
| Message-ID: | JGEPJNMCKODMDHGOBKDNOEOKCNAA.joel@joelburton.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In the following code the "first_time" column is a time type.. without time
zone.
select * from visitorhistory
where visitorhistory.first_time > current_time - interval '10 minutes'
The result
ERROR: Unable to identify an operator '>' for types 'time without time
zone' and 'time with time zone'
You will have to retype this query using an explicit cast (State:S1000,
Native Code:7)
Stuffed if I can make this work. Can some one point me in the right
direction?
WHERE timetz(first_time) > current_time - interval '10 minutes'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-05-13 17:51:17 | Re: don't know how to get SELECT |
| Previous Message | Steve Lane | 2002-05-13 17:47:01 | Re: Can This be done |