On Thu, Feb 1, 2018 at 6:55 AM, Chris Green <c...@isbd.net> wrote:
> 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?
-- horrible way
SELECT CASE strftime("%w",DateInRow)
WHEN 0 THEN "Sun"
WHEN 1 THEN "Mon"
WHEN 6 THEN "Sat"
END AS DayOfWeek
> Chris Green
> sqlite-users mailing list
I have a theory that it's impossible to prove anything, but I can't prove
sqlite-users mailing list