I think "week of the month" is not a standard value. As with week of the year,
is week #1 the week in which the month starts, the first complete week within
the month, or the first week with at least 4 days?
----- Original Message -----
From: Jose Isaias Cabrera <jic...@outlook.com>
To: sqlite-users@mailinglists.sqlite.org <sqlite-users@mailinglists.sqlite.org>
Sent: Thursday, May 2, 2019, 21:44:44
Subject: [sqlite] Getting the week of the month from strftime or date functions
Greetings.
To break Manuel's constant bug finding emails, :-), I want to get the week of
the month from either date or strftime functions. I know I can get the week of
the year by doing,
SELECT strftime('%W','2019-03-07');
but I need to get the week of that month based on the date. I can write a
quick function to do it, but I thought there was an option for it, but I
couldn't find it in the help site[1]. Is there such a choice?
Thanks.
[1] https://www.sqlite.org/lang_datefunc.html
SQLite Query Language: Date And Time
Functions<https://www.sqlite.org/lang_datefunc.html>
The only reasons for providing functions other than strftime() is for
convenience and for efficiency. Time Strings. A time string can be in any of
the following formats:
www.sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
