sqlite error with timezones

John Griffiths wrote:

Any ideas where I should look, have this error while deploying to

ActiveRecord::StatementInvalid (PGError: ERROR: function
strftime(unknown, timestamp without time zone, unknown) does not exist
LINE 1: SELECT strftime('%Y', created_at) as year, strftime('...

I've checked the SqlLite documentation but can't find anything regarding
this, the timezone is set in the Rails app, weird error

rake time:zones:local
to find your current time zone setting.
check your config/environment.rb, find the following statement:
  config.time_zone = 'UTC'
change it to whatever you want.