I found this very interesting,
15:52:46.71>sqlite3
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT strftime('%W','2019-01-01');
00
sqlite> SELECT strftime('%W','2019-01-02');
00
sqlite> SELECT strftime('%W','2019-01-03');
00
sqlite> SELECT strftime('%W','2019-01-04');
00
sqlite> SELECT strftime('%W','2019-01-05');
00
sqlite> SELECT strftime('%W','2019-01-06');
00
sqlite> SELECT strftime('%W','2019-01-07');
01
I expected 2019-01-01 to be part of week 1, since it was Tuesday. So, back to
the drawing board. ;-) Thanks.
Thomas Kurz, on Thursday, May 2, 2019 04:01 PM, wrote...
To: SQLite mailing list
Subject: Re: [sqlite] Getting the week of the month from strftime or date
functions
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<http://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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
