Feld 'Datum' kann nicht als Typ DateTime angesprochen werden.

[Aviator]

Zitat von himitsu:

Alles, was es nicht zuordnen kann, wird als TEXT behandelt.

Das ist so nicht richtig. Die Erkennung des Datentyps wird nach einem festen Schema abgearbeitet. Trifft keine Regeln zu, dann ist der Datentyp Numeric.

Zitat von SQLite Documentation:

3.1. Determination Of Column Affinity
The affinity of a column is determined by the declared type of the column, according to the following rules in the order shown:

1. If the declared type contains the string "INT" then it is assigned INTEGER affinity.
2. If the declared type of the column contains any of the strings "CHAR", "CLOB", or "TEXT" then that column has TEXT affinity. Notice that the type VARCHAR contains the string "CHAR" and is thus assigned TEXT affinity.
3. If the declared type for a column contains the string "BLOB" or if no type is specified then the column has affinity BLOB.
4. If the declared type for a column contains any of the strings "REAL", "FLOA", or "DOUB" then the column has REAL affinity.
5. Otherwise, the affinity is NUMERIC.

Note that the order of the rules for determining column affinity is important. A column whose declared type is "CHARINT" will match both rules 1 and 2 but the first rule takes precedence and so the column affinity will be INTEGER.

Quelle: https://www.sqlite.org/datatype3.htm...olumn_affinity

[DeddyH]

Und ergänzend dazu:

Zitat:

2.2. Date and Time Datatype

SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as TEXT, REAL, or INTEGER values:

TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS").
REAL as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian calendar.
INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC.
Applications can chose to store dates and times in any of these formats and freely convert between formats using the built-in date and time functions.

[Devil1925]

Vielen Dank! Ihr habt mir viel weiter geholfen! jetzt funktioniert alles!