RC6: Trouble with DATETIME NOT NULL DEFAULT 0 after ALTER TABLE in VB6

[tmighty2]

Edit: I ran the following query:

Set r = CnEx.OpenRecordset("SELECT rowid, datum, typeof(datum) AS datum_type, quote(datum) AS raw_value FROM jscodes ORDER BY datum DESC")

And I got this:

Record 401, field "rowid, value: 200"
Record 401, field "datum, value: 03.09.2025 20:46:09"
Record 401, field "datum_type, value: text"
Record 401, field "raw_value, value: '03.09.2025 20:46:09'"