Postgres Pro
Downloads
Home   >   mailing lists

Re: Fetching Date and Timestamp values - Mailing list pgsql-odbc

From Dev Kumkar
Subject Re: Fetching Date and Timestamp values
Date
Msg-id CALSLE1NtT=nUGJ2d9K3tZJ0-O28RHU+vJDpFqDM5gb7Yo2c2=A@mail.gmail.com
Whole thread Raw
In response to Fetching Date and Timestamp values  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: Fetching Date and Timestamp values  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-odbc
Tree view
On Wed, May 14, 2014 at 10:19 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Hi,

Am facing issue while fetching Date and Timestamp values.

GetSqlData call as follows:

SQLGetData(my_stmt, my_col_no, SQL_C_CHAR, taget_var, sizeof(taget_var), &my_buff_len)

Above call returns empty value. Am missing anything obivious here?

Driver version - 9.2.1
Platform - RHEL 64-bit

Regards...

Over here the target column's type is SQL_DATE or SQL_TIMESTAMP, and am trying to get them as SQL_C_CHAR.
Just wanted to check if SQL_C_CHAR is the correct and what is the standard way to fetch SQL_DATE or SQL_TIMESTAMP.

Regards...

pgsql-odbc by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: Fetching Date and Timestamp values
Next
From: David G Johnston
Date:
Subject: Re: Fetching Date and Timestamp values