Don’t think you’ll get it any less ugly than
substr('SunMonTueWedThuFriSat',strftime('%w',Date)*3+1,3);
without defining your own functions.
From: Chris Green<mailto:c...@isbd.net>
Sent: 01 February 2018 13:13
To:
sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org>
Subject: [sqlite] Easiest way to get day of week as a string (not a number)?
I want to get Sun, Mon, Tue, Wed etc. from a date, what's the easiest
way of doing this in a sqlite select?
I guess I can do something (horrible?) with the numeric day of week
and substr() but is there not an easier way?
--
Chris Green
·
_______________________________________________
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
