Forum > Databases

SQLite3 Date Problem

<< < (11/11)

silvercoder70:

--- Quote from: Zvoni on December 06, 2024, 11:54:12 am ---
--- Quote from: Thaddy on December 06, 2024, 11:53:07 am ---Even for local databases - which SQLite isn't - it makes sense to always handle dates as UTC unless it is for your mother's agenda application.(i.e. hobby programmers)

--- End quote ---
Since when is SQLite NOT a local Database?

--- End quote ---

I'm with you Zvoni :) I regard it as local as well.

There are many ways this cat can be skinned (relatively speaking) ... (1) strftime() works, (2) setting up on DisplayText handler at the field level, or (3) setting displayFormat of column?

Also I would only though store a date/datetime as a numeric of sometime that easily allows for the date functions to be used on the field in a query, and that is whether I'm working in seconds, hours, days or months. Don't have to make it harder than it needs to be. (I also have a couple of vids on (1) and (2) as well.)

Navigation

[0] Message Index

[*] Previous page

Go to full version