Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with Date in WHERE clause using Oracle via ODBC

Re: Problem with Date in WHERE clause using Oracle via ODBC

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Tue, 25 Mar 2003 15:47:56 -0800
Message-ID: <v8ydnXJxt7FMdx2jXTWciA@giganews.com>


Wihtout a sample code snippet we can tell you little. There are several ways of doinf date comparisons via ODBC, so that is not enough information.

"David G Stevens" <David_at_les-arbres.co.uk> wrote in message news:b5qli3$4bk$1_at_newsg2.svr.pol.co.uk...
> I've seen a couple of reports of problems using date comparisons in WHERE
> clauses when querying Oracle via ODBC. Does anyone have details of which
> versions of the ODBC driver are affected or what else can cause this -
e.g.
> NLS default date format.
>
> The problem cropped up for me in mid February and I'm trying to figure out
> what may have been changed on either the client machine (ODBC drivers) or
at
> the host db end.
>
> Appreciate any responses.
>
> David
>
>
Received on Tue Mar 25 2003 - 17:47:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US