From 2009e374e82aa54c122d10f3c00a7defddab3a4c Mon Sep 17 00:00:00 2001
From: Roy Ben-Shabat <Roy@Twine-s.com>
Date: Thu, 5 Mar 2020 18:31:05 +0200
Subject: Fixed issue with job mixing. Fixed issue with LogViewer scroll and
 session logs.

---
 Software/DB/Scripts/Select With Local Datetime.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 Software/DB/Scripts/Select With Local Datetime.sql

(limited to 'Software/DB/Scripts/Select With Local Datetime.sql')

diff --git a/Software/DB/Scripts/Select With Local Datetime.sql b/Software/DB/Scripts/Select With Local Datetime.sql
new file mode 100644
index 000000000..f0c22ea91
--- /dev/null
+++ b/Software/DB/Scripts/Select With Local Datetime.sql	
@@ -0,0 +1,2 @@
+SELECT CONVERT(datetime, SWITCHOFFSET(START_DATE, DATEPART(TZOFFSET, 
+START_DATE AT TIME ZONE 'Israel Standard Time'))) as LOCAL_TIME, * FROM JOB_RUNS ORDER BY START_DATE DESC
\ No newline at end of file
-- 
cgit v1.3.1

