Re: SQL-Error-Code 591???

You're just missing a space between the day and the hour. Apart from that Pankajs original answer should work, ie: CREATE TABLE SOME_NAME ( execution_dat datetime year to fraction(3)default datetime (1900-01-01 00:00:00.000) year to fraction(3) not null ) >>> Peter Ulrich <p.ulrich@corag.de> 07/20/00 01:18pm >>> Hi Pankaj, thanx for your reply! Unfortunately your suggestion didn't solve the problem. I get a syntax error (code 201) instead, as well as with the following variations: CREATE TABLE SOME_NAME ( execution_dat datetime year to fraction(3)default datetime year to fraction(3) (1900-01-0100:00:00.000) not null ) nor this: CREATE TABLE SOME_NAME ( execution_dat datetime year to fraction(3)default datetime (1900-01-0100:00:00.000) not null ) Any more ideas? Regards Peter