Hi guys, i'm not new to sql, but its my first time using mysql. i am creating a new table and keep getting errors when trying to insert a date feild or time feild:

create table MessageBoard
(
MessageID char(10) not null,
MemberID char(10) not null,
Topic varchar(50) not null,
Description varchar(250) not null,
Expiry_Date date 'yyyy-mm-dd' not null,
Start_time time 'hh:mm:ss',
Date/Time timestamp 'yyyy-mm-dd hh:mm:ss' not null,

CONSTRAINT MessageBoard_pk
PRIMARY KEY (MessageID),
);
I keep getting a syntax error for the two date feilds and time feild? i havn't got a clue what i'm doing wrong? is inserting a date feild different in mysql to SQL server?

i'd appreciate any help plzzzz, thanks for your time...

Those are the correct types, but you don't have to say anything more than date or timestamp. You can't specify yyyy-mm-dd since they are only accepted that way and don't accept other input.

You can use DATE_FORMAT when pulling your results to format the date or timestamp in various ways. See the manual for that.

thanks 4 da advice