"Gene Allen" <g...@bystorm.com> wrote in
message
news:!&!AAAAAAAAAAAuAAAAAAAAAKY/0q6/55xppdwmexdclhybajwnk16tjt5kmprugns9ymeaaaaaem8aabaaaaafb8zhbqucrj+kez0vnifiaqaaa...@bystorm.com
> I'm missing something simple since I can't seem to get it to work.
> Here is an example of how I'm trying to get the week number:
>
> date(datetime(eventtime, 'unixepoch', 'localtime'), '%W')
>
> based on http://www.sqlite.org/lang_datefunc.html
Your construct doesn't remotely resemble anything described on that
page. You want something like
strftime('%W', eventtime, 'unixepoch', 'localtime');
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
