Default Datetime?

2001-06-26 Thread Richard Bates
r(100) ); Create table( CreationDateDATETIMEDEFAULT "CURRENT_DATE()", Infovarchar(100) ); All without the quote return with invalid syntax. With the quote inserts "000-00-00 00:00:00" meaining invalid date. ======

Creating Table with a Default Datetime field

2001-06-26 Thread Richard Bates
r(100) ); Create table( CreationDateDATETIMEDEFAULT "CURRENT_DATE()", Infovarchar(100) ); All without the quote return with invalid syntax. With the quote inserts "000-00-00 00:00:00" meaining invalid date. ======