Azure and GetDate

[SBarnes]

Hi Mike,

Do the Jiwa stored procedures do anything in terms of GetDate to adjust for time zones?

[Scott.Pearce]

No.

[Scott.Pearce]

To elaborate:

We only use SQL Server time for concurrency control. Other date/times (ie. posted date, etc.) are from the client machine.

[SBarnes]

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