SysDateTime and GetDate Timezone

[taylorswiftlover]

Hello, 

Wondering if someone can provide me an answer to this. I know that when I set a DataType to TimeStamp, I can easily edit the timezone to its design:

 

But when I use calculated field/value and use SysDateTime, how do I set its timezone?

 

 

[Alison]

Hello @taylorswiftlover,

According to the documentaion, SysDateTime() function returns  current system timestamp. More details can be found here:
https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetime-transact-sql?view=sql-server-ver15

Also, you can use the following function to get UTC date and time - SYSUTCDATETIME()

To make it more relevant to another timezone you should use Dateadd() function. More details can be found here:
https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15

Hope it helps.

[taylorswiftlover]

On 4/1/2020 at 7:09 AM, Alison said:

Hello @taylorswiftlover,

According to the documentaion, SysDateTime() function returns  current system timestamp. More details can be found here:
https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetime-transact-sql?view=sql-server-ver15

Also, you can use the following function to get UTC date and time - SYSUTCDATETIME()

To make it more relevant to another timezone you should use Dateadd() function. More details can be found here:
https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15

Hope it helps.

Thank you @Alison!!!

[GoodBoy]

Hi there! I reached out to their support to confirm the time zone returns by SysDateTime().

As per them, it will always return time in Pacific Standard Time since all the Caspio databases are in PST. 

[Lepidoptera]

Alternatively, you can create a Virtual that will have a timestamp on load. This will accurately get the System Time that you have setted-up for your app.