Re: VB4, Oracle, ODBC

Article View: comp.databases.oracle.misc

Article #150

Back to comp.databases.oracle.misc Previous Next

#150

From: Matthias Gresz
Date: Tue, 24 Feb 1998 00:00

38 lines
2028 bytes

On 23 Feb 1998 15:17:47 GMT, "Jonathan Sayce" <jon.sayce@iname.com> wrote:

Hi,

issue SELECT field FROM table WHERE date_field = to_date('24-Apr-1996','DD-MM-YYYY');
>The scene:
>
>	An Oracle 7.1 db on Netware, a Win 3.11 pc, and an ODBC link from a 16-bit
>VB 4 app.
>
>The problem:
>
>	While I can insert a date into the Oracle system in the format
>"dd-mmm-yy", I cannot run a query on a certain date. The following query
>reports that there is a 'type mismatch':
>
>	SELECT field FROM table WHERE date_field = '24-Apr-96'
>
>The date is sent as a string, enclosed in single quotes.
>
>If anyone can suggest how to get round this - either the correct way to
>query a date via ODBC to Oracle or where in the Oracle system I can find
>the full date syntax - I and many others will be eternally grateful.
>
>Cheers,
>Jon.
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa@T-online.de

Technical Details

Message-ID: <6ctv0o$kcb$6@news00.btx.dtag.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bd406d$7a6208e0$9af982c1@sedgely>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,9167d3a68f653c69
X-Google-Attributes: gidfb53f,public
X-Google-Thread: f99a8,9167d3a68f653c69
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 104586,9167d3a68f653c69
X-Google-Attributes: gid104586,public
X-Google-Thread: 114664,9167d3a68f653c69
X-Google-Attributes: gid114664,public
X-Google-Thread: 10be7f,9167d3a68f653c69
X-Google-Attributes: gid10be7f,public
X-Google-Thread: 112235,9167d3a68f653c69
X-Google-Attributes: gid112235,public
From: GreMa@t-online.de (Matthias Gresz)
Subject: Re: VB4, Oracle, ODBC
Date: 1998/02/24
Message-ID: <6ctv0o$kcb$6@news00.btx.dtag.de>
X-Deja-AN: 328114088
Content-Transfer-Encoding: 8bit
References: <01bd406d$7a6208e0$9af982c1@sedgely>
Mime-Version: 1.0
Reply-To: GreMa@t-online.de
X-Sender: 0722193570-0001@t-online.de
Content-Type: text/plain; charset=iso-8859-1
Organization: T-Online
Newsgroups: comp.databases.oracle.misc,fido7.rdbms.oracle,hannover.uni.comp.oracle,microsoft.public.vb.database,microsoft.public.vb.database.dao,microsoft.public.vb.database.odbc

Reply to Parent Message