sqlite error with timezones

John Griffiths wrote:

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

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   

run: 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.