Re: ODBC Oracle 7 Clause Where with a Field Date
From: Lasse Halaas <reklame.halaas_at_c2i.net>
Date: Wed, 05 Jan 2000 17:46:36 GMT
Message-ID: <0sLc4.12742$zI2.614988_at_juliett.dax.net>
Date: Wed, 05 Jan 2000 17:46:36 GMT
Message-ID: <0sLc4.12742$zI2.614988_at_juliett.dax.net>
Hello, I have used SQL through MS Oracle ODBC with functions like TO_CHAR and TO_DATE, so I guess your SQL could be written something like
select date_birth from emp where dat_in = to_date('01011999','ddmmyyyy')
Y2K ready and all :-)
I must tell you that I've experienced problems with the Oracle DBC driver in conection with Microsoft software. Nothing new under the sun there.
Lasse from Norway
tet skrev i meldingen <83fg69$ed3$1_at_news2.isdnet.net>...
>Please,
>
>How i can write a clause where in ODBC SQL format
>
> ? select date_birth from emp where dat_in = #01/01/99#
>
>Can i use sql function like TO_date ... TO_CHar
>
>Thank for you help
>
>
>
Received on Wed Jan 05 2000 - 18:46:36 CET