Commit timestamp timezone in spanner change stream

[simonl07]

Hi,

I am trying to query a spanner change stream using python SDK following this guide: 

https://cloud.google.com/spanner/docs/change-streams/details

However I noticed that in `data_change_record` the `commit_timestamp` field is always -07:00 which is my local timezone. Is there anyway to force the commit_timestamp to always be in UTC ('Z' or '-00:00') when querying change stream?

I wanted to avoid converting it to UTC in my script if this can be done more natively.

I've tried to change my local system timezone to UTC and got the same result, it seems like somewhere GCP is still detecting that I am in from pacific time. I went through any user / project settings but to no avail.

[robertcarlos]

Hi @simonl07,

Welcome to Google Cloud Community!

You can add a commit timestamp depending on which database dialect you're currently using:

• Commit timestamps in GoogleSQL-dialect databases 
• Commit timestamps in PostgreSQL-dialect databases 

Hope this helps.