Re: 'infinity'::timestamp not translated correctly using ODBCv7.01.00.10 ?

> -----Original Message-----
> From: Kristis Makris
>
> Hello,
>
> I'm issuing the following SQL statement through psql:
>
> mydb=# select 'infinity'::timestamp as reply;
>   reply
> ----------
>  infinity
> (1 row)
>
>
> When I try to issue the same statement through VC++ in the following
> piece of code I get back "2002-03-28 00:00:00". Is infinity somehow
> effectively translated into now()::date || "00:00:00" by the driver?

There's no concept of inifinity in the timestamp type of ODBC(and in
many DBMSs).

regards,
Hiroshi Inoue