Re: Possible Y2K trap in using DECODE?

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 11 Jan 1999 23:09:08 GMT
Message-ID: <369a6064.2298099@news.siol.net>

On Mon, 11 Jan 99 17:07:47 GMT, e-mail.address_at_my.sig (Gerard M. Averill) wrote:

>In article <3699203e.42677404_at_news.siol.net>, jmodic_at_src.si (Jurij Modic)
>wrote:
>
>snip
>
>INSERT INTO destination_table (date_column)
> SELECT to_date(
> DECODE(char_date, '00000000', NULL, '01010001', NULL, char_date)
> , 'DDMMYYYY')
> FROM temp_table;
>
>I've had the default date format bite me, too, and have learned to avoid
>relying on it. Hope this helps.

Gerard,

Your sollution is by far the easiest and the best for this case.

Thanks!

>Gerard
>
>----
>Gerard M. Averill, Researcher
>CHSRA, University of Wisconsin - Madison
>GAverill<at>chsra<dot>wisc<dot>edu

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Jan 11 1999 - 17:09:08 CST