Datetime value is incorrect in Database

Help
,
1

Hi,
when I checked the Jobs table data in database times are in correct , But they are correct in Orchestrator . Turkey time-zone is GMT+3. I database log time-zone is GMT.

How can i fix the problem?

Orch:

Orchestrator
Orchestrator1144×182 13.5 KB

Database

database
database1191×278 15.5 KB

Thanks

2

Update the select query with your time zone.

SELECT
StartTime AT TIME ZONE ‘Pacific Standard Time’ AS OrderDate_TimeZonePST

Ref - AT TIME ZONE (Transact-SQL) - SQL Server | Microsoft Learn

Regards,
Karthik Byggari

3 Likes
3

How can i fix the problem while inserting data to database.

4

Not sure about how insert works in this case.
Trail and error method.

Regards,
Karthik Byggari

3 Likes