On windows select Now() returns the local DateTime on the server, on Linux select now() returns the UTC datetime.

I'm currently working on a fix for this where we read the datetime from an online service, has anyone got a better solution? Can I persuade Sisense to convert a UTC DateTime to a local DateTime