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
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
I have a theory that it's impossible to prove anything, but I can't prove
it.
Maranatha! <><
John McKown
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
