again with the query tweaks, substr() instead of strftime()
it should be default but it wont hurt to set anyway, utf8
change strftime() to substr() in our views as well!
change last instances of strftime() to substr()
comments