I'm having a small integration issue with rodauth-rails, sequel and the sequel-activerecord-connnection gem, when performing date operations.
My issue is a particular query where I do: .where(Sequel[oauth_grants_expires_in_column] >= Sequel::CURRENT_TIMESTAMP) The main problem is that, when using plain sequel, datetimes are stored in localtime, while in rails, they're converted to utc and stored. In itself, this shouldn't be a problem, however, the resulting query from the abovet subset is: AND (`expires_in` >= datetime(CURRENT_TIMESTAMP, 'localtime'))) this evaluates well when datetime rows are stored in localtime, but not when the row is utc, i.e. it seems that CURRENT_TIMESTAMP could benefit from knowing the timezone in which a datetime is stored, however I'm not sure how difficult that would be. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/f901c2c4-7db6-4405-b22b-d9d006f9d653%40googlegroups.com.
