Re: Oracle - Anfängerfrage zu Datentyp DATE

Florian Melcher schrieb:

INSERT INTO T1 (YEAR_MONTH, NR)
SELECT '2005-07', A.NR
FROM T2 A;


You have to use the to_date function.

INSERT INTO T1 (YEAR_MONTH, NR)
SELECT to_date('2005-07', 'yyyy-mm'), A.NR
FROM T2 A;

You can control the output in your query using the to_char function.

hth,
Moritz
.