Re: [sqlite] ISO8601 8-byte packed date type

- 2007-03-05 12:34:56.789 Day of Year dates - 2007-365 Week dates - 2007-W51-7 If anyone would find this useful/helpful please let me know. Tom tolson at whamware.com Tom Olson wrote: Hello to all, I am working on an 8-byte data type that stores date time and timezone information

[sqlite] ISO8601 8-byte packed date type

Hello to all, I am working on an 8-byte data type that stores date time and timezone information and provides helper routines for date arithmatic as well as conversion to/from strings, julian dates, UNIX date times, etc... The type can be stored in a 64-bit integer or as an 8 byte blob. The

[sqlite] Precision of dates stores as Julian real

Hello, I know that SQLite uses a 64-bit floating point type to store Julian date information. Is this accurate to the second or a fraction of a second? I was doing some testing and tried to format a date using strftime() method with the %f option and I was unable to find a date that kept any

[sqlite] Does SQLITE support RESEEDing of AUTOINCREMENT fields

Hello, Is there a function or PRAGMA that tells the database engine to recalculate the next sequence number for an AUTOINCREMENT column of a table (i.e. PRAGMA reseed('tablename')? Regards, Tom -- View this message in context:

[sqlite] Question regarding REPLACE INTO and last row ID

Hello, If a REPLACE INTO statement is executed and the there is an existing row that is replaced will sqlite3_last_inserted_rowid return the rowid of the record that was changed? -- View this message in context: