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

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Kristis Makris" <kristis(dot)makris(at)datasoft(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: 'infinity'::timestamp not translated correctly using ODBCv7.01.00.10 ?
Date: 2002-03-29 16:29:13
Message-ID: EKEJJICOHDIEMGPNIFIJKEBEHFAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kristis Makris 2002-03-29 16:38:24 Re: 'infinity'::timestamp not translated correctly using
Previous Message Hiroshi Inoue 2002-03-29 16:29:07 Re: psqlODBC ODBC3.0/Column Names