Re: Fetching Date and Timestamp values

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Fetching Date and Timestamp values
Date: 2014-05-14 21:33:14
Message-ID: CALSLE1NtT=nUGJ2d9K3tZJ0-O28RHU+vJDpFqDM5gb7Yo2c2=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Wed, May 14, 2014 at 10:19 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)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...

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message David G Johnston 2014-05-14 21:40:46 Re: Fetching Date and Timestamp values
Previous Message Dev Kumkar 2014-05-14 21:32:51 Re: Fetching Date and Timestamp values