Oracle via ODBC : changing date and time format

From: Peter Hörsemann <ph_at_grafische-informatik.com>
Date: Thu, 30 Jul 1998 11:26:33 +0200
Message-ID: <35c03c1b.0@news.teuto.de>

I'm connecting an Oracle DB via ODBC from our application running under WindowsNT(drivers from Oracle and Microsoft). How can I achive that DATE fields are shown in the various localized formats ?

If I do, for example,

ALTER SESSION SET NLS_DATE_FORMAT = 'dd.mm.yyyy hh24:mi:ss'

only the format for queries changes, the resulting fields are still of the standard

yyyy-mm-dd hh:mm:ss format.

Peter Hoersemann
g.i. grafische informatik

ph_at_grafische-informatik.com Received on Thu Jul 30 1998 - 04:26:33 CDT