SysDateTime and GetDate Timezone

[taylorswiftlover 0]

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 15]

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 0]

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!!!