Unable to migrate to V17 on Linux

[nikolajlauridsen]

Which Umbraco version are you using?

V17

Bug summary

The MigrateSystemDatesToUtc migration doesn't run on Linux when you use SQLServer.

Specifics

The issue is in the UPDATE {tableName} SET {columName} = {columName} AT TIME ZONE '{timezoneName}' AT TIME ZONE 'UTC' SQL statement.

The AT TIME ZONE command relies on windows to convert the datetime value as described here, this is also the case for Azure SQL

Steps to reproduce

1. Use Linux and SQLServer
2. Install on V16
3. Try and migrate to V17

Expected result / actual result

No response

---

This item has been added to our backlog AB#56088