SQLite and dates

[Emanuel_Kury]

Please excuse the words „the hell“ and „Jesus Christ“.

I was very aroused yesterday.

Listfixer did nothing to help.
Now I will store it in a Textfield.

Thank You very much for your help and please excuse.

Emanuel

[ABG]

FAQ Section: SQLite

Tutorials SQLite documentation Related tables. SimpleSqlite extension. Pharmacy example - @Juan_Antonio Web SQL Database in Browser. JavaScript. HTML5 - @Juan_Antonio Fun with SQLite, AI2, Google Sheets - @TIMAI2 HOWTO: php SQLite3 as server database with AI2 - TimAI2 HOWTO: Use sqlite3 with @Juan_Antonio’s Terminal Extension - TimAI2 Extensions PuraVidaApps SQLite extension - Taifun Some SQLite samples - Peter Thomson Thomas Bennedum SQLite extension (obsolete) Simple SQLite extensio…

I added a link to the official Sqlite documentation page yesterday.

It's interesting reading, especially the section on how Sqlite handles data types for dates compared to other SQL engines

If you store a number in a Sqlite date field , it's interpreted as seconds from 1970.

That is 1000 times off from AI2 clock milliseconds.

[Emanuel_Kury]

S O L U T I O N

1. TIMAI2 was right. Dates should be converted to Milliseconds.
2. Store the Value in a Textfield (important!)
3. You can select the value then, from your DB use it like an integer and make calculations with it.
4. You don‘t have to buy any extensions from ‚whoever‘.
   The most interesting methods can be found at the CLOCK-Widget.
5. The ListFixer sounds good, but did not work in my case. I cleaned the things, I selected from the DB by myself. (some experts will shout now
   
   
6. !!! Don‘t throw away your nerves and use strong language !!! It doesn‘t help anything.
7. keep cool and good luck!