| bio | website | |
|---|---|---|
| location | United States | |
| age | ||
| visits | member for | 1 year, 1 month |
| seen | Mar 25 at 19:22 | |
| stats | profile views | 1 |
|
Jan 28 |
awarded | Popular Question |
|
Apr 22 |
awarded | Student |
|
Apr 4 |
awarded | Supporter |
|
Apr 4 |
awarded | Scholar |
|
Apr 4 |
accepted | Compare a date and a timestamp with time zone with now() in the same query? |
|
Apr 4 |
comment |
Compare a date and a timestamp with time zone with now() in the same query? I get the following error with your query: [Err] ERROR: operator does not exist: text > timestamp with time zone. This was my original query on all databases until I ran into this original error when querying this one machine with expiration stored as a timestamp+timezone. I'm also querying a view, does the view convert datatypes to text or something? |
|
Apr 3 |
asked | Compare a date and a timestamp with time zone with now() in the same query? |