On Mon, Mar 22, 2021 at 10:02 AM Remtech Industries < [email protected]> wrote:
> I have connected Sequel to 2 databases. MSSQL(Read-only, cannot change > Schema), and PostgreSQL. > > The PostgreSQL database stores all timestamps in UTC, and the MSSQL stores > all timestamps in local timezone. > > The Sequel.default_timezone sets the default for all DBs, is there a way > to set the default timezone per database or even per database table? > Sequel::Database#timezone= allows for per-database timezones. Sequel does not support per-table timezones. If you want that, you can create a separate Sequel::Database object with the same connection settings and use it for access to the table that needs a different timezone setting. Thanks, Jeremy -- 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/CADGZSScBRTV%3DoYoJvOWS1dXLgeok%2ByFjE%3DxmCfgkMP4-c5-C_A%40mail.gmail.com.
