SQLite Forum

Bug ? Same query that works in shell produces constraint violation when run by a C program with sqlite3_{prepare,bind,step}
Yes, you are correct -- the UTC modified does nothing for a localized timestring.  When a localized timestring is parsed a flag is set so that the 'utc' operator does nothing.