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
