SQLite and datetime

[argumentum]

#include <SQLite.au3>
#include <SQLite.dll.au3>
Local $aRow
_SQLite_Startup()
ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF)
_SQLite_Open() ; open :memory: Database
_SQLite_Exec(-1, "CREATE TEMP TABLE settings (key,other int,value datetime);")
_SQLite_Exec(-1, "INSERT INTO settings (key,other,value) VALUES ('1','not an int','setting one');")
_SQLite_Exec(-1, "INSERT INTO settings (key,other,value) VALUES ('2','1','setting two');")
_SQLite_Exec(-1, "INSERT INTO settings (key,other,value) VALUES ('3','3','setting Three');")
_SQLite_Exec(-1, "INSERT INTO settings (key,other,value) VALUES ('4','4','setting Four');")
_SQLite_QuerySingleRow(-1, "SELECT value FROM settings WHERE other > '1';", $aRow) ; Select single row and single field !
MsgBox(0, "One of the values for other > 2:", $aRow[0])
_SQLite_Close()
_SQLite_Shutdown()

why does it work ?, is it all text ?, should it not reject an invalid type ?

I'd like to use datetime but it inserts it as text =/

[jchd]

SQLite uses manifest typing (aka dynamic typing), which allows you to store any type anywhere. Of course you still can force strong typing if you feel you need it (you don't). In addition it also implements column affinity.

It doesn't have a datetime type. You can store timestamps as text or integer or float. Read the doc about types.

You definitely need to read SQLite documentation, particularly this part. Reading the rest will only benefit you, anyway.

Besides, you shouldn't quote integer litterals for INT columns (like column other in your example)..

[argumentum]

SQLite uses manifest typing (aka dynamic typing), which allows you to .....

thank you for the answer =)