Re: Forms: problem with parameter

From: Dirk Bellemans <Dirk.Bellemans_at_skynet.belgium>
Date: Thu, 12 Aug 1999 08:27:51 +0200
Message-ID: <7otq83$2g7$2@news0.skynet.be>

Steve Cosner wrote in message <7nfltr$3p4$1_at_nntp.csufresno.edu>...

>It does not matter how the field is formatted. When you build the
>where clause, the client's default date format is used unless you
>specify the format. Try this:
>
>sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN To_date('''
> ||to_char(:DATE_BLOCK.START_PLAN,'YYYYMMDD')
> ||''',''YYYYMMDD'') AND To_date('''
> ||to_char(:DATE_BLOCK.END_PLAN,'YYYYMMDD')
> ||''',''YYYYMMDD'')'
> ||' ORDER BY CALIBRACAO.PROXIMA';
>
>Steve Cosner

You'll loose the index when using functions. This may have disastrous results on the query time...

Isn't is possible to change the date format for the duration of the session?

--
Dirk Bellemans
Modify email address to reply (use .be instead of .belgium) Received on Thu Aug 12 1999 - 01:27:51 CDT