Skip to Content.
Sympa Menu

freetds - RE: date format in ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: date format in ODBC
  • Date: Wed, 31 Jul 2002 17:50:39 +0200


>
> Hi,
>
> Could someone who has the wherewithal find something out for me ?
>
> I would like to know the string format that is returned from
> the ODBC api,
> when a datetime column is bound to a character variable (SQL_C_CHAR)
>
> by ODBC , i DON'T mean the FreeTDS ODBC API. It is this I am
> trying to fix
> so that it is behaviourally identical with other ODBC drivers.
>
> Thanks a lot.
>
> Bill
>
Doing a convert from "SELECT GETDATE()" to SQL_C_CHAR "2002-07-31
17:45:44.123"

Server and client work with english settings. I think this is a unique
format (for all country settings), trying to configure Italian give same
result.

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page