Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
CRM 4.0 filtered view - переход на летнее и зимнее время

質問 CRM 4.0 filtered view - переход на летнее и зимнее время

  • Tuesday, December 27, 2011 3:49 PM
     
      Has Code
    Sign In to Vote
    0

    Установлен CRM 4.0 Rollup 20

    Как работать с filtered view ?

    В них не учитывается отмена перехода на летнее/зимнее время.

    use [ORG_MSCRM]

SELECT TOP 100 [createdon], [createdonutc], 
	DATEDIFF (hour, [createdonutc], [createdon]), 
	dbo.fn_UTCToLocalTime([createdonutc]) 'fn_UTCToLocalTime', 
	DATEDIFF (hour, [createdonutc], dbo.fn_UTCToLocalTime([createdonutc]))
FROM [dbo].[FilteredAccount]
WHERE [createdon] between '2011-12-01' and '2011-12-31'
OR [createdon] between '2010-12-01' and '2010-12-31'
OR [createdon] between '2009-06-01' and '2009-06-30'
OR [createdon] between '2009-12-01' and '2009-12-31'
order by [createdon]

     

    createdon	createdonutc	(No column name)	fn_UTCToLocalTime	(No column name)
2009-06-01 16:36:24.000	2009-06-01 12:36:24.000	4	2009-06-01 16:36:24.000	4
2009-06-01 16:37:08.000	2009-06-01 12:37:08.000	4	2009-06-01 16:37:08.000	4
2009-06-01 16:38:01.000	2009-06-01 12:38:01.000	4	2009-06-01 16:38:01.000	4
2009-06-01 16:48:08.000	2009-06-01 12:48:08.000	4	2009-06-01 16:48:08.000	4
2009-12-11 16:38:28.000	2009-12-11 13:38:28.000	3	2009-12-11 16:38:28.000	3
2010-12-23 14:27:21.000	2010-12-23 11:27:21.000	3	2010-12-23 14:27:21.000	3
2011-12-06 11:20:44.000	2011-12-06 08:20:44.000	3	2011-12-06 12:20:44.000	4
2011-12-15 11:34:58.000	2011-12-15 08:34:58.000	3	2011-12-15 12:34:58.000	4
2011-12-20 21:33:17.000	2011-12-20 18:33:17.000	3	2011-12-20 22:33:17.000	4
2011-12-26 13:14:24.000	2011-12-26 10:14:24.000	3	2011-12-26 14:14:24.000	4
2011-12-26 18:34:30.000	2011-12-26 15:34:30.000	3	2011-12-26 19:34:30.000	4