Discussions relating to plugin development, and the Jiwa API.
by SBarnes » Mon Feb 04, 2019 3:28 pm
Hi Mike,
Do the Jiwa stored procedures do anything in terms of GetDate to adjust for time zones?
Regards
Stuart Barnes
-
SBarnes
- Shihan
-
- Posts: 1620
- Joined: Fri Aug 15, 2008 3:27 pm
- Topics Solved: 175
by Scott.Pearce » Mon Feb 04, 2019 3:32 pm
No.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
-
Scott.Pearce
- Senpai
-
- Posts: 743
- Joined: Tue Feb 12, 2008 11:27 am
- Location: New South Wales, Australia
- Topics Solved: 221
-
by Scott.Pearce » Mon Feb 04, 2019 3:33 pm
To elaborate:
We only use SQL Server time for concurrency control. Other date/times (ie. posted date, etc.) are from the client machine.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
-
Scott.Pearce
- Senpai
-
- Posts: 743
- Joined: Tue Feb 12, 2008 11:27 am
- Location: New South Wales, Australia
- Topics Solved: 221
-
by SBarnes » Mon Feb 04, 2019 3:39 pm
Hi Scott
The following although hard coded will work to replace GetDate it is in some stored procedures we have inherited as part of a system
- Code: Select all
CREATE FUNCTION [dbo].[udf_GetDateSyd]()
RETURNS DateTime
AS
BEGIN
DECLARE @D datetimeoffset;
SET @D = CONVERT(datetimeoffset, SYSDATETIMEOFFSET()) AT TIME ZONE 'AUS Eastern Standard Time';
return (CONVERT(datetime,@D));
END
GO
Regards
Stuart Barnes
-
SBarnes
- Shihan
-
- Posts: 1620
- Joined: Fri Aug 15, 2008 3:27 pm
- Topics Solved: 175
Return to Technical and or Programming
Who is online
Users browsing this forum: No registered users and 13 guests