Oh yes, I meant don’t store as an ID in its string format!
replyIt's just s dumb as storing dates as strings, but people still do it.
replyBut SQLite does not have a native datetime type so you have to use strings
replyYou can use an integer
replyHow do I know the time zone of an integer? Sure there are plenty of cases where one doesn't care, but there are also many cases where the original time zone is important.
replyThe integer is a UTC time so it can be sorted. If you need the time zone you store than in a smaller field.
replyother comment said it already, timezone information is not saved. Easiest is just to use a string.
replyBut also one of the recommended ways of doing it, as it has no native Datetime type.
reply