timestamp as varchar(23)

This is a multi-part message in MIME format.

------_=_NextPart_001_01C86D73.597B1960
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm trying to get some "timestamp without time zone" column's value as a
varchar(23) value.

The SQLBindCol() function is used for this purpose in my C++ app.

However the result string doesn't contain milliseconds part at all while
the real column's value contains it ('2007-12-23 10:00:01.123' for
example).

After SQLFetch() the result's buffer contains '2007-12-23 10:00:01'
only.

The same program works fine with a MSSQLServer database so I cannot
suppose that there is something wrong in my app.

OS: WinXP SP2

"PostgreSQL 8.3.0, compiled by Visual C++ build 1400"

ODBC Driver: PostgreSQL Unicode 08.03.01.00

Additional connection string settings:

ByteaAsLongVarbinary=3D1; TextAsLongVarchar=3D1; =
MaxVarcharSize=3D8000;
BoolsAsChar=3D0; BI=3D-5; LFConversion=3D0; LowerCaseIdentifier=3D0;

How can I get "milliseconds part" in this case?

Thank you.

------_=_NextPart_001_01C86D73.597B1960
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DRU link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

<o:p> </o:p>

I’m trying to get some =
“timestamp without
time zone” column’s value as a varchar(23) =
value.<o:p></o:p>

The SQLBindCol() function is used for this =
purpose
in my C++ app.<o:p></o:p>

However the result string doesn’t =
contain
milliseconds part at all while the real column’s value contains it
('2007-12-23 10:00:01.123' for example). <o:p></o:p>

After SQLFetch() the result’s buffer =
contains
'2007-12-23 10:00:01’ only.<o:p></o:p>

The same program works fine with a =
MSSQLServer
database so I cannot suppose that there is something wrong in my =
app.<o:p></o:p>

<o:p> </o:p>

OS: WinXP SP2<o:p></o:p>

"PostgreSQL 8.3.0, compiled by Visual =
C++
build 1400"<o:p></o:p>

ODBC Driver: PostgreSQL Unicode =
08.03.01.00<o:p></o:p>

Additional connection string =
settings:<o:p></o:p>


ByteaAsLongVarbinary=3D1; TextAsLongVarchar=3D1; MaxVarcharSize=3D8000;
BoolsAsChar=3D0; BI=3D-5; LFConversion=3D0; =
LowerCaseIdentifier=3D0;<o:p></o:p><=
/p>

<o:p> </o:p>

How can I get “milliseconds =
part” in
this case?<o:p></o:p>

<o:p> </o:p>

Thank you.<o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C86D73.597B1960--

Sergey.Zubkovsky [ Di, 12 Februar 2008 13:32 ] [ ID #1923700 ]

Re: timestamp as varchar(23)

Zubkovsky, Sergey wrote:
> Hi,
>
> I=92m trying to get some =93timestamp without time zone=94 column=92s v=
alue as a
> varchar(23) value.
>
> The SQLBindCol() function is used for this purpose in my C++ app.
>
> However the result string doesn=92t contain milliseconds part at all wh=
ile
> the real column=92s value contains it ('2007-12-23 10:00:01.123' for
> example).
>
> After SQLFetch() the result=92s buffer contains '2007-12-23 10:00:01=92=
only.

could you try the driver on testing for 8.030101 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hiroshi Inoue [ Do, 14 Februar 2008 01:18 ] [ ID #1924006 ]

Re: timestamp as varchar(23)

Yes, it works now!
I hope that the fixed driver will be released ASAP.
Thank you.

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue [at] tpf.co.jp]
Sent: Thursday, February 14, 2008 3:18 AM
To: Zubkovsky, Sergey
Cc: pgsql-odbc [at] postgresql.org
Subject: Re: [ODBC] timestamp as varchar(23)

Zubkovsky, Sergey wrote:
> Hi,
>
> I'm trying to get some "timestamp without time zone" column's value as
a
> varchar(23) value.
>
> The SQLBindCol() function is used for this purpose in my C++ app.
>
> However the result string doesn't contain milliseconds part at all
while
> the real column's value contains it ('2007-12-23 10:00:01.123' for
> example).
>
> After SQLFetch() the result's buffer contains '2007-12-23 10:00:01'
only.

could you try the driver on testing for 8.030101 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sergey.Zubkovsky [ Do, 14 Februar 2008 13:58 ] [ ID #1924007 ]