Skip to content
Advertisement

Tag: strftime

SQLite Incomplete Time String

I have a table with incomplete time strings, such as ‘0:09.735’ (minutes:seconds.milliseconds). As the function strftime expects certain formats, such as ‘%H:%M:%f’, I have “to complete” the incomplete timestring first. The first strftime function with the complete timestring shows the correct result, the second, third, and fourth one with the incomplete timestring do not. Is there a flexible way that

Advertisement