UTC timestamp value issue with SQL anywhere 17

[former_SQLA_member1694879]

we have declared the below column with table 1.

last_chg_utc datetime null default utc timestamp,

while inserting the row against table 1, default value is automatically populated for last_chg_utc column

The problem is default value is inserting with adding future date for every insert. For ex: today date is 08-11-2023 , default value is setting as 09-11-2023 for every insert it is incrementing the date value

Note: we are not setting any value against (last_chg_utc column) by default it is settting the value

kindly let us know why it is inserting the future date value by default.

how to resolve this automatic date increment issue

[former_SQLA_member1694879]

What is the date on the host server?

[former_SQLA_member1694919]

host server date is EST time today date

[former_SQLA_member1694879]

If it's a Windows server run this in Powershell - it should output the date in UTC as you want it in SQL Anywhere - if it's not, then you need to look at the host server as your problem.

Get-Date -date (Get-Date).ToUniversalTime()-uformat %y%m%d%H%M%j

[former_SQLA_member1694919]

How do you "check" the timestamp values, i.e. with what query, and what is exactly displayed?

After inserting a row into a table UTC timestamp column has been populated with the future date