SQLite Forum

Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step}

Thanks, Richard - good point!
My code now treats the timestamp as a 64-bit integer, multiplies it by 
1,000,000, and adds the microseconds.