pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to convert date to tm
2+ messages / 2 participants
[nested] [flat]
* Unable to convert date to tm
@ 2004-02-10 20:45 Ramiro Arenas R <ramiroa@coordinadora.com>
2004-02-15 22:02 ` Re: Unable to convert date to tm Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Ramiro Arenas R @ 2004-02-10 20:45 UTC (permalink / raw)
To: pgsql-sql
Hi
I have a column x in a table of type date and i have an index on x
runing the query "SELECT * FROM table WHERE x >= '2004-01-01"
i get this:
Unable to convert date to tm
where using a cast like this: "SELECT * FROM table WHERE x
>='2004-01-01::timestamp" result is ok but it doesn't use index.
Thanks in advance.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Unable to convert date to tm
2004-02-10 20:45 Unable to convert date to tm Ramiro Arenas R <ramiroa@coordinadora.com>
@ 2004-02-15 22:02 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-02-15 22:02 UTC (permalink / raw)
To: Ramiro Arenas R <ramiroa@coordinadora.com>; +Cc: pgsql-sql
Ramiro Arenas R <ramiroa@coordinadora.com> writes:
> I have a column x in a table of type date and i have an index on x
> runing the query "SELECT * FROM table WHERE x >= '2004-01-01"
> i get this:
> Unable to convert date to tm
AFAICT, that error message hasn't existed in PG since 7.1. If you
are running 7.1.* or older, I'd suggest an update. The particular
issue here seems to be that 7.1 does not contain a workaround for
broken mktime() library routines that reject dates before 1970.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-02-15 22:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-10 20:45 Unable to convert date to tm Ramiro Arenas R <ramiroa@coordinadora.com>
2004-02-15 22:02 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox