September 2004 Entries
If you work with SQL Server 2000 and FOR XML functionality, you curse Query Analyzer probably as often as I do. Here are some tips for improving the output: In QA, set “Maximum Characters per Column” setting to 2033 Execute DBCC TRACEON(257) to pretty-print the XML output http://www.winnetmag.com/SQ
You can convert local datetime values to UTC datetime values, and vice-versa, using the built-in GETUTCDATE() function: DECLARE @LocalDate DATETIMESET @LocalDate = GETDATE() -- convert local date to utc dateDECLARE @UTCDate DATETIMESET @UTCDate = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), @LocalDate) -- convert utc date to local dateDECLARE @LocalDate2 DATETIMESET @LocalDate2 = DATEADD(Hour, DATEDIFF(Hour, GETDATE(), GETUTCDATE()), @UTCDate) SELECT @LocalDate, @UTCDate, @LocalDate2 Note...