Originally posted by alaios
thx for help...but this does not work....what are the differneces between mysql and oracle sql
I am using oracle 8i personal edition?
As far as the SQL goes not a whole lot of differences except that mysql doesn't support all the sql that oracle or other RDBMS's support. Main difference between them would be datatypes. Each DBMS has slight differences in what kind of datatypes it has. DateTime datatype is probably different between the two if I recall correctly. I use oracle db's at work and mysql for my web developing at home. Date fields are the trickiest datatype to work with when working with databases.
What is your date field set to? Which datatype and what constraints if any have you set on it?