Thank u very much!!! :)
the end of the week can be
select (case strftime('%w', T) when '0' then T else date(T, 'weekday 0')
end)
from (select date('now') as T);
--or
Igor Tandetnik wrote:
>
> helemacd wrote:
>> anybody know how to return the start of the week and end of the
>> week???
>
> select (case strftime('%w', T) when '0' then T else date(T, 'weekday 0',
> '-7 days') end)
> from (select date('now') as T);
>
> -- or
>
> select date(T, '-' || strftime('%w', T) || ' days')
> from (select date('now') as T);
>
> This is start of the week, assuming the US convention of beginning the
> week on Sundays. End of the week is left as an exercise for the reader.
>
> Igor Tandetnik
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://www.nabble.com/Week-tp24795944p24796813.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
