No announcements
Found 2316102 threads
-
0 VotesSQL Server AT TIME ZONE inconsistency
Posting the same question (stackoverflow) in a different forum will not change the answer.Answered | 2 Replies | 982 Views | Created by Nullsie - Friday, November 6, 2020 3:21 PM | Last reply by scott_morris-ga - Friday, November 6, 2020 7:14 PM
-
0 Votes
SQL Server Time Zone settings
That's quite the time difference, hope you're not on-call ;) SQL Server doesn't maintain it's own time, it just inherits it ...Answered | 2 Replies | 5740 Views | Created by tdavfc - Tuesday, March 24, 2015 10:34 AM | Last reply by tdavfc - Tuesday, March 24, 2015 11:23 AM -
0 Votes
SQL Server 2017 AT TIME ZONE & sys.time_zone_info
User-893317190 posted Hi KALYANA ALLAM, Not clear about how sqlsver decides is_currently_dst, but if you want to apply current_utc_offset, ...Answered | 2 Replies | 180 Views | Created by Anonymous - Saturday, February 23, 2019 7:05 AM | Last reply by Anonymous - Monday, February 25, 2019 6:40 AM -
0 Votes
SQL Server 2008: Default time zone
The GETDATE() function returns the date and time from the operating system: "Returns the current database system timestamp as a datetime value without the database time ...Answered | 2 Replies | 15604 Views | Created by Joining 3 or more tables - Sunday, July 12, 2009 6:11 PM | Last reply by Joining 3 or more tables - Monday, July 13, 2009 5:19 AM -
0 Votes
Time zone issue in sql server 2008r2.
As URI pointed out you should leverage DATETIMEOFFSET data type introduced in SQL Server 2008.Answered | 4 Replies | 5515 Views | Created by S K D - Thursday, November 3, 2011 7:37 AM | Last reply by Ashish Kumar Mehta - Thursday, November 3, 2011 11:29 AM -
0 Votes
Need the SQL Query to check SQL time zone and change the time zone
Hi All, I am using SQL Server 2008 SP2.Answered | 3 Replies | 3084 Views | Created by Gautam R - Monday, March 2, 2015 4:12 PM | Last reply by Gautam R - Tuesday, March 10, 2015 4:43 AM -
0 Votes
TIME ZONE
SQL Server uses the Windows time zone.Answered | 2 Replies | 2074 Views | Created by guaro555 - Monday, May 13, 2013 5:30 PM | Last reply by Alberto Morillo - Monday, May 13, 2013 5:45 PM -
3 Votes
install sql server 2017
Choose a database engine upgrade method and choose the one suits you best.Answered | 3 Replies | 1477 Views | Created by sa ba - Wednesday, January 2, 2019 7:48 PM | Last reply by Puzzle_Chen - Thursday, January 3, 2019 1:40 AM -
0 Votes
Is there a way to convert time zones in SQL Server 2008/2012?
Which timezone, the SQL Server or the client?Answered | 2 Replies | 1833 Views | Created by imsam67 - Wednesday, January 23, 2013 7:39 PM | Last reply by Tom Phillips - Wednesday, January 23, 2013 9:03 PM -
0 Votes
Databases for Multi Time Zone
The workaround is to use SWITCHOFFSET() function to calculate the time based on a time zone offset.Answered | 4 Replies | 2120 Views | Created by MalikJaved - Monday, March 24, 2014 2:55 PM | Last reply by tracycai - Tuesday, March 25, 2014 6:02 AM -
0 Votes
Time Zone issue
If I may make a suggestion, I think what you really want is the ability to show all the times in a given time zone of your choosing where that may differ ...Answered | 3 Replies | 1303 Views | Created by Ben.Warren - Wednesday, January 11, 2017 12:43 AM | Last reply by Conor Cunningham [MSFT] - Friday, January 20, 2017 2:19 PM -
0 Votes
Downgrade of SQL Server 2017 to SQL Server 2012
>Please suggest me how can i get the licence for SQL Server 2012.Answered | 3 Replies | 1915 Views | Created by praveenkumar18 - Monday, November 5, 2018 7:52 AM | Last reply by pituach - Monday, November 5, 2018 8:42 AM -
2 Votes
How to convert client date time to UTC date time in sql server
1) Since you do not know the client's time zone you have to use your database server time zone.Answered | 8 Replies | 10761 Views | Created by Sudip_inn - Monday, January 23, 2017 1:59 PM | Last reply by Guoxiong Yuan - Wednesday, January 25, 2017 2:44 PM -
1 Votes
SQL Server 2017
Yes its released for public ...Answered | 2 Replies | 1004 Views | Created by Revathi jayakrishnan - Tuesday, March 13, 2018 12:03 PM | Last reply by Visakh16 - Tuesday, March 13, 2018 12:30 PM -
0 Votes
SQL Server 2017 Express and Management Studio 2017
https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/Answered | 4 Replies | 6410 Views | Created by IvoIm - Monday, July 23, 2018 10:50 AM | Last reply by Emily Fei - Tuesday, July 24, 2018 8:01 AM -
0 Votes
New features in SQL server 2017?
Does this helpsAnswered | 2 Replies | 910 Views | Created by rocky541 - Saturday, October 6, 2018 5:44 PM | Last reply by Mohsin_A_Khan - Saturday, October 6, 2018 6:11 PM -
2 Votes
Imapct of the Time zone change in Database server
Tibor Karaszi, SQL Server MVP (Web Blog)Answered | 4 Replies | 3108 Views | Created by SNIVAS - Monday, June 20, 2016 7:57 AM | Last reply by TiborK - Monday, June 20, 2016 9:55 AM -
0 Votes
Convert time Zone
Unfortunately, SQL Server doesn't provide effective method to change time zone of date time unlike .NET which can use .NET framework globalization file to ...Answered | 3 Replies | 1027 Views | Created by Priya Bange - Monday, May 4, 2015 5:30 AM | Last reply by Manu Kapoor - Monday, May 4, 2015 6:02 AM -
3 Votes
Unattended Installation of SQL Server 2017
And the file is in the folder which is named by the time you installed before.Answered | 2 Replies | 1810 Views | Created by Mark Goulter - Tuesday, June 5, 2018 12:02 AM | Last reply by Emily Fei - Tuesday, June 5, 2018 6:19 AM -
4 Votes
Time zone
change server time zone 1:00 AM to 1:10 AM...Answered | 11 Replies | 1991 Views | Created by subu999 - Tuesday, February 11, 2014 8:31 PM | Last reply by Shanky_621 - Wednesday, February 12, 2014 1:38 PM - Items 1 to 20 of 2316102 Next ›
No announcements
