Hi
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.
