Re: Y2K question!!

Mr. Steve Cosner gave me an excellent answer for similar question

I would like to thank Steve Cosner for his suggestion.when I had similar problem.

Hope this helps you too.

select your_values WHERE your_table.your_column BETWEEN To_date('''

  ||to_char(:DATE_BLOCK.START_DATE,'YYYYMMDD')
  ||''',''YYYYMMDD'') AND To_date('''
  ||to_char(:DATE_BLOCK.END_DATE,'YYYYMMDD')
  ||''',''YYYYMMDD'')'
  || ORDER BY your_table.your_column_order;

Jonathan Lewis wrote:

> Remember that by 31-Dec-1999 7.3.4 will be
> the lowest supported version of Oracle.
>
> Apart from that, your test needs a re-write.
> > select to_char(to_date(last_day('01-feb-00'),'dd-mon-
> rr'),'MM/DD/RRRR')
> > from dual
>
> The last_day() call has already returned 28-feb-00 (meaning 1900)
> before you apply the to_date() function.
>
> Try (e.g. unless I have the brackets wrong):
> select
> to_char(last_day(to_date('01-feb-2000','dd-mon-yyyy')),'mm/dd/yyyy')
> from dual;
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

--
Breno de Avellar Gomes
DBMS Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342 Toll free fax and voice recorder from USA 1-888-EXCITE2 extension 291-303-8152

Outside USA (international fares apply) 1-917-463-3173 Received on Fri Sep 10 1999 - 19:29:35 CDT