KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a simple SQL for calculating week number in my reports on SQLite SELECT STRFTIME('%W', 'date_column') It was correct for 2009-2012. In 2013 I got always the wrong week number. For example SELECT STRFTIME('%W', '2012-02-28') return '09' and this is correct. SELECT STRFTIME('%W', '2013-02-28') return '08' and this is wrong. We have the 9th week. Is there something in SQLite date time functions that I don't understand? Or is it a bug of SQLite?
Tags (comma-separated)
Save Edits
Cancel