TO_DATE discrepancy V7 vs V6

From: Guy Harel <guy_at_mais.hydro.qc.ca>
Date: Mon, 27 Sep 1993 15:27:37 GMT
Message-ID: <guy.749143657_at_tdsb-s>

I found the following discrepancy between the TO_DATE function in V6 and V7.

  create table temp (nom_fichier char(10), date_observation date)

In 6, the following works:

  insert into temp(nom_fichier, date_observation)   values ('test',to_date('080588','DD/MM/YY'))

In 7, it errs like this:

  values ('test',to_date('080588','DD/MM/YY'))

                       *

  ERROR at line 2:
  ORA-01843: not a valid month

Investiguating the problem in the documentation, I found that the date format of the TO_CHAR function has changed from V6 to V7 and that 'Punctuation reproduced in the result' seems no longer supported in V7. (Sql lang ref, v6, p4-37).

I understand that our v6 usage of the function is problably faulty, using a TO_CHAR date format modal in a TO_DATE. But still, this incompatibility should have been documented somewhere.

For your info.

--

---

Guy Harel			                  guy_at_hydro.mais.qc.ca	

Software Consultant
Systematix Inc. ( Montreal ) Received on Mon Sep 27 1993 - 16:27:37 CET