Oracle and Date field problem

Kemarin aku ngerjain proyek. Nah, disalah satu modul ada yang berhubungan dengan tanggal. Karena terbiasa dengan mysql maka aku langsung HAJAR aja dengan query :

INSERT INTO tbl_data(id, tanggal) VALUES(1, '03-feb-2005')

. Execute program dan muncullah pesan cinta dari oracle. Error codenya : ORA-01858. Oke, beberapa hari yang lalu aku bikin query yang serupa (walau tak sama) dan sukses.

Oke lah, kita googling sebentar. Ternyata kesalahannya karena setiap query tanggal di oracle harus menggunakan fungsi TO_DATE().

Author: Arief Bayu Purwanto

Hello, my name is Arief Bayu Purwanto, a 24 years old father of a beautiful daughter. Interested in online programming, linux, games, and reading. Currently working on kapanlagi.com as junior developer. I live in a relatively quite and cool place called Malang. I'm available for some freelance stuff as well as some consulting job. You can see my portofolio for some previous task I've finished and some other information related to my capability. Btw, I'm plurking here.