Re: Forms: problem with parameter

[Quoted] 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 [Quoted] results on the query time...

[Quoted] 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)