Re: TO_DATE

#1

Jay Northrop wrote:

Quote:

This one might be a simple one for you, but I searched the archives
and couldn't find anything that would help.

I am having a problem running queries against an Oracle RDB database
using JDBC (sorry, I don't know the version of RDB) that use the
TO_DATE function.

The queries is a very simple one:

select dob from inmate where DOB IN TO_DATE('06/19/1967',
'MM/DD/YYYY')

The error is:

%SQL-F-TRUNCPARAM1, Routine TO_DATE expects 3 Parameters

Now, I am familiar with running Oracle SQL queries, but I'm not
terribly familiar with a 3rd parameter. I've done some looking around
and found that it is an NLS environment variable of some sort, but I'm
not sure what it should be. Any help would be appreciated.

Jay Northrop

Hello,

This statements is ok. But perhaps ths parser gets problems with the TRUNC
Just some suggestion:

1) SELECT dob FROM inmate WHERE TRUNC(dob) IN
(TRUNC(TO_DATE('06/19/1967', 'MM/DD/YYYY')))

or

2) SELECT dob FROM inmate WHERE TRUNC(dob) = TRUNC((TO_DATE('06/19/1967
00:00:00', 'MM/DD/YYYY HH:MI:SS'))))

Hope this helps ?

Best regards
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: TO_DATE

comp.databases.rdb comp.databases.rdb

Re: TO_DATE - 04-09-2004 , 06:51 AM