How to fix the timezone when using dataview

What I’m trying to do

When I use date() in dataview tables, the timestamp gets converted to a different timezone. For example -

table without id
date("2023/01/01 00:00:00-07:00","yyyy/MM/dd HH:mm:ssZ")
from [[]]

When this table gets rendered, it shows the value as 2022/12/31 23:00:00-8

The conversion is correct, but I’d prefer it keeps the timezone as -07.

How can I do that?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.