Re: [INTERFACES] ODBC DATE PROBLEM

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: Pierluigi <pgsql(at)sif(dot)it>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ODBC DATE PROBLEM
Date: 1998-08-06 03:05:00
Message-ID: 199808060305.MAA13230@mustang.sdc.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I am not sure about Access but I use ODBC from Excel and VB.

I leave my backend in default date mode (US private format) but rely on the
ODBC driver to switch itself to ISO format (as I recall, this approach was
decided by consensus a few months back).

In VB, this seems to be converted to whatever I select in the Control Panel
Regional Settings.

Sometimes I also use the VB Format function to manipulate the raw input format.

HTH,
Stephen.

========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 1998-08-06 03:53:58 Large objects names
Previous Message Matthew Hagerty 1998-08-06 01:29:26 Re: [INTERFACES] postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?