Andrew Chalk wrote:
> I have an SQL Server database that uses 'datetime' fields. I want to write
> to these with SQLBindParameter(). What SQL type should I specify?
>
> If I use SQL_TYPE_TIMESTAMP I get errors from SQLExecute() and
> SQLGetDiagRec() states that there is an overflow.
>
> Many thanks.
>
>

"Andrew Chalk" <achalk@magnacartasoftware.com> wrote:

"Dmitriy Ivanov" <divanov_NOSP@M_aha.ru> wrote in message
news:djn94e$1v1m$2@news.aha.ru...
> Hello Andrew,
> "Andrew Chalk" <achalk@magnacartasoftware.com> wrote:
>
> AC> I have an SQL Server database that uses 'datetime' fields. I want
> AC> to write to these with SQLBindParameter(). What SQL type should I
> AC> specify?
> AC>
> AC> If I use SQL_TYPE_TIMESTAMP I get errors from SQLExecute() and
> AC> SQLGetDiagRec() states that there is an overflow.
>
> Have you tried SQL_TIMESTAMP instead?
> --
> Sincerely,
> Dmitriy Ivanov
> Common Lisp ODBC interface - www.ystok.ru
>
>

"Richard Marsden" <noreply@nospam.winwaed.com> wrote in message
news:ZrmdnaXFRota7sLeRVn-gw@comcast.com...
> Andrew Chalk wrote:
>> I have an SQL Server database that uses 'datetime' fields. I want to
>> write to these with SQLBindParameter(). What SQL type should I specify?
>>
>> If I use SQL_TYPE_TIMESTAMP I get errors from SQLExecute() and
>> SQLGetDiagRec() states that there is an overflow.
>>
>> Many thanks.
>
> I've managed to get dates to work by binding an SQL_DATE_STRUCT object in
> SQLBindParameter. And you set the type to: SQL_C_TYPE_DATE.
>
> TIME and TIMESTAMP should be similar (SQL_TIMESTAMP_STRUCT, etc.
> You can then get/put the individual days,months,hours,etc from these
> structures. (I have to map them to/from an existing date class that the
> customer has provided me with)
>
>
> Richard
> --
> Richard Marsden
> Winwaed Software Technology, http://www.winwaed.com
> http://www.mapping-tools.com for MapPoint tools and add-ins