Mailing List ArchiveSupport open source code!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]datetime queries in postgres
- To: tlug@example.com
- Subject: datetime queries in postgres
- From: vp@example.com (Viktor Pavlenko)
- Date: 23 May 2001 19:30:16 +0900
- Content-Type: text/plain; charset="ISO-2022-JP"
- Reply-To: tlug@example.com
- Resent-From: tlug@example.com
- Resent-Message-ID: <O_50DB.A.TDB.JF5C7@example.com>
- Resent-Sender: tlug-request@example.com
I'm having some very strange problems in Postgres (7.0.2) There's a DATETIME field in the table. Most of queries with this field give wrong results: >SELECT time FROM tb; 2001-05-18 07:45:26+09 2001-05-18 07:45:28+09 2001-05-18 08:58:06+09 2001-05-18 08:58:06+09 >SELECT * FROM tb WHERE time > '2000-05-18 8:00:00'; 2001-05-18 07:45:26+09 2001-05-18 07:45:28+09 2001-05-18 08:58:06+09 2001-05-18 08:58:06+09 >SELECT * FROM tb WHERE time < '2000-05-18 8:00:00'; (0 rows) Adding +9 to the time string doesn't change anything. (and I omit the one I started with, BETWEEN thing) What am I doing wrong? Viktor
- Follow-Ups:
- Re: datetime queries in postgres
- From: Jake Morrison <jake_morrison@example.com>
Home | Main Index | Thread Index
- Prev by Date: Re: REGEXP in perl questiion
- Next by Date: Re: Mini-nomikai Friday
- Prev by thread: Re: REGEXP in perl questiion
- Next by thread: Re: datetime queries in postgres
- Index(es):
Home Page Mailing List Linux and Japan TLUG Members Links