Sqlite error with timezones

Rails
1

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

2

John G. 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.

3

PGError comes from postgres adapter, not sqlite, you might want to
look at PostgreSQL: Documentation instead of the sqlite
docs.

On Sep 18, 8:58 pm, John G. [email protected]

4

yep, i was trying to push an app to Heroku, little did i know it takes
mysql or sqlite db’s and dumps them into PostGreSQL format.

i’ll eventually crack the importing, gonna try a smaller app before the
big one.

thanks for the help.