Hello everybody!
To be compatible with other applications i want to change the default of
some date and datetime columns
The datetime format of my database(7.0) is EUR
>From SQL_STUDIO(7.5) i did:
*datetime column
alter table bskopf column geloescht alter default '9999-12-31
00:00:00.0000'
Ok
*date column
alter table bskopf column druckdatum alter default '9999-12-31'
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-4018 POS(28) Unknown default
alter table bskopf column DRUCKDATUM alter default '9999-12-31'
Did i missunderstood something ???
Any help welcomed
Best regards
Albert Beermann
'''''
'''''''''
(0 0)
+---------oOO-----------(_)------------------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de <http://www.piepenbrock.de/>
|
+--------------------------------------oOO----------------+
|__|__|
|| ||
ooO Ooo
