[sqlite] Data storage : Boolean and Date

Hi all, I'm new to the list, and I can't find any archive to look trough... My questions was : - what is the best way to store date-time values with sqlite3? - to store boolean values? I assume INTEGER is the solution, but I wanted to know if there was some convention about that... Thanks for

Re: [sqlite] Data storage : Boolean and Date

Romain Perney wrote: - what is the best way to store date-time values with sqlite3? This depends on what you plan to do with them. If you need to manipulate the dates in your SQL queries (as opposed to just shuffling them in and out), then you want one of the formats understood by SQLite's

Re: [sqlite] Data storage : Boolean and Date

Thanks a lot Igor, that's just what I wanted to know. Igor Tandetnik wrote: / - what is the best way to store date-time values with sqlite3? / This depends on what you plan to do with them. If you need to manipulate the dates in your SQL queries (as opposed to just shuffling them in and out),