Date variable problem

[picard]

:confused: Sorry to bother you, I'm really new to all this....

I created a table in mySQL with

Res_in date default NULL

When I insert a value with:

insert into Reservat (Res_in) values (2007-07-01)

The data I get when I call for it is: 0000-00-00 Can anybody tell me what I'm doing wrong!

Thank you and sorry for the dumb question!

[bubbisthedog]

Hey, that's what this forum's here for! Try this:

insert into Reservat (Res_in) values ('2007-07-01')