Change time in sql server 2014

Navigation
1

Good morning, as can be seen in the image below, I made a select to get the current date and it is at +3.

How can I change this date / time?

    
asked by anonymous 20.06.2016 / 15:52

1 answer

2

SQL Server uses by default the regional settings that are determined in your Windows.

You can only change your server configuration:

Control Panel - > Region & Language - > Change Location - > Change Format and Location

More like you do not have access you can create a Query that uses the DATEADD function subtracting the 3 hours, this way: 

SELECT DATEADD(HOUR, -3, GETDATE())

Result:

    
20.06.2016 / 16:15
How to check if a data exists in storage Values based on the last day of each month (Excel)