"Gene Allen" <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
