Viya Time Zone Issue

Sekhar2 — Thu, 29 Jan 2026 09:07:21 GMT

Our customer is in the process of migrating from 9.4 Grid to Viya4. There is one issue with time zone. When users ran sql pass thru statement, number of records that are pulled is different from 9.4 to Viya. When we looked at the records more closely, there is a time difference of 11 hours. Both these environments are in Australia. In Viya , for every compute context we set the time zone option to "Australia/Sydney". Still we are getting different number of records from 8.4 and Viya.

Query runs something like

cast(term_time as timestamp) >= '2025-09-04 09:00:00'

and cast(term_time as timestamp) <= '2025=09-04 09:05:00'

This is for Redshift and same issue is for Oracle too.

Strange thing is since this is a pass thru, we thought database will handle the time stamp. But apparently SAS is also influencing this query.

Any suggestions? Thanks in advance for any help.

Re: Viya Time Zone Issue

Kurt_Bremser — Thu, 29 Jan 2026 10:14:42 GMT

Disclaimer: I have no Viya experience.

SAS has always used an external client for database access. I think that your database clients on the Viya server have a wrong timezone configured.

topic Viya Time Zone Issue in Moving to SAS Viya

Viya Time Zone Issue

Re: Viya Time Zone Issue