| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Server and Client SQL statements work differently?
A copy of this was sent to Doug <dpeel_at_mindspring.com>
(if that email address didn't require changing)
On Thu, 06 Aug 1998 08:54:40 -0500, you wrote:
>Hello all... I'm having a problem that I can't seem to solve. If I run
>
>a SQL statement involving a date/time on the server machine, everything
>works fine Ex:
>
>SELECT * FROM psms_db.down_hist WHERE datestamp > '06-Aug-1998 00:00:00'
>
looks like the NLS_DATE_FORMAT on the server is set to something like "dd-mon-yyyy hh:24:mi:ss"
>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
>
and the nls_date_format is set to 'dd-mon-yyyy' on this client.
>run the SQL statement without the time portion:
>
>SELECT * FROM psms_db.down_hist WHERE datestamp > '06-Aug-1998'
>
try
select * from T where datestmp > to_date( '06-Aug-198 00:00:00', 'dd-mon-yyyy hh24:mi:ss' )
and it will work in all environments....
>It works fine. Problem is, I need to be able to query based on time and
>
>date. System is running Oracle 8 Server on NT 4.0 Server with Oracle 8
>ODBC Driver Version 8.00.0300. Client machine is Oracle 8 Client
>Installation on NT 4.0 Workstation using same Oracle 8 ODBC Driver.
>
>Any and all suggestions are appreciated.
>
>dpeel_at_removethis.mindspring.com
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Aug 06 1998 - 10:13:12 CDT
 |
 |