SQLite Forum

Week numbers in queries
Login
Is there a reason why '%V' is not recognized by SQLite ?

 %V     The  ISO 8601  week  number  (see NOTES) of the current year as a decimal number, range 01 to 53, where
              week 1 is the first week that has at least 4 days in the new year.  See also %U  and  %W.   (Calculated
              from tm_year, tm_yday, and tm_wday.)  (SU)

 %w     The  day  of  the  week  as  a  decimal,  range 0 to 6, Sunday being 0.  See also %u.  (Calculated from
              tm_wday.)

 %W     The week number of the current year as a decimal number, range 00 to 53, starting with the first Monday
              as the first day of week 01.  (Calculated from tm_yday and tm_wday.)