Re: Client and Server SQL statements work differently??

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Thu, 6 Aug 1998 15:56:42 +0100
Message-ID: <6qcg72$e51$1@schbbs.mot.com>

Use the TO_DATE function to convert your test date string to date format.

I recomment always using the TO_DATE function and never assuming a date format will be the default one for a particular database instance.

--
Alan D. Mills

Doug wrote in message <35C9B50E.68D06E70_at_mindspring.com>...
>works fine Ex:
>
>SELECT * FROM psms_db.down_hist WHERE datestamp > '06-Aug-1998 00:00:00'
>
>If I run the exact same SQL statement from a client machine (I've tried
>the Oracle ODBC test application and SQL worksheet) I get the error
>"S1000: ORA-01830: date format picture ends before converting entire
>input string 40002"
>
>Basically the time portion of the SQL statement is being rejected. If I
>run the SQL statement without the time portion:
>
>SELECT * FROM psms_db.down_hist WHERE datestamp > '06-Aug-1998'
>
Received on Thu Aug 06 1998 - 09:56:42 CDT