Sorry, No code snippets found.

Comments or Responses

Posted by: Bandi on: 9/2/2013 Level:Platinum | Status: [Member] [MVP] | Points: 10
Hi Bagesh Kumar Singh,
The following first SELECT gives me error....
SELECT DATEPART(TZoffset, GETDATE()) AS 'Time Zone'   -- Error: The datepart tzoffset is not supported by date function datepart for data type void type.

SELECT DATEPART(TZoffset, SYSDATETIME()) AS 'Time Zone' -- Gives output 0... This is fine

Login to post response