באג 2000 ב אורקל 8i
try this code. DROP TABLE KUKU; CREATE TABLE KUKU (D DATE); INSERT INTO KUKU VALUES (TO_DATE(´19801010´,´YYYYMMDD´)); INSERT INTO KUKU VALUES (TO_DATE(´19991010´,´YYYYMMDD´)); INSERT INTO KUKU VALUES (SYSDATE); COMMIT WORK; SELECT TO_CHAR(TO_DATE(D),´MM/YYYY´) FROM KUKU; I do a to_date on a date field , it suppose to have no affect , but it does! It returns the dates as 10/2080 and 10/2099 respectively. A 100 year difference! Be warned!
try this code. DROP TABLE KUKU; CREATE TABLE KUKU (D DATE); INSERT INTO KUKU VALUES (TO_DATE(´19801010´,´YYYYMMDD´)); INSERT INTO KUKU VALUES (TO_DATE(´19991010´,´YYYYMMDD´)); INSERT INTO KUKU VALUES (SYSDATE); COMMIT WORK; SELECT TO_CHAR(TO_DATE(D),´MM/YYYY´) FROM KUKU; I do a to_date on a date field , it suppose to have no affect , but it does! It returns the dates as 10/2080 and 10/2099 respectively. A 100 year difference! Be warned!