locked
DateTime2 data type support for change tracking RRS feed

  • Question

  • According to the warning information in my trace file DateTime2 data type is not supported which is pitty because it offers "accuracy of 100ns" which combined with default value getutcdate() maybe makes it (IMHO) as good as time stamps with additional human readable content

    Any plans to start supporting DateTime2 data type in v3?

    Thanks,
    Nikola

    WARNING, w3wp, 18, 02/21/2010 09:44:41:731, Microsoft.Synchronization.Data.SchemaException: SqlSyncAdapterBuilder column 'DateCreated' cannot be used by SqlSyncAdapterBuilder as a change tracking column. The column has a data type that is not supported for change tracking. Supported data types are as follows: datetime, int, bigint, timestamp, binary, and varbinary.
    Sunday, February 21, 2010 9:55 AM

Answers

  • DateTime2 is not currently supported.  Do you mind using DateTime instead?

    Thus far - the developement team does not have a plan to enable DataTime2 to be recognized/supported from the SqlSyncAdapterBuilder object. 

    Thanks.
    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 22, 2010 7:59 PM
    Answerer

All replies

  • DateTime2 is not currently supported.  Do you mind using DateTime instead?

    Thus far - the developement team does not have a plan to enable DataTime2 to be recognized/supported from the SqlSyncAdapterBuilder object. 

    Thanks.
    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 22, 2010 7:59 PM
    Answerer
  • EF4 somehow prefers the DateTime2 as a data type so that might be causing minor inconveniences but nothing which cannot be tackled.

    Anyhow, the answer you provided even being negative is the info I was looking for

    Thanks!

    Monday, February 22, 2010 11:23 PM
  • EF4 somehow prefers the DateTime2 as a data type so that might be causing minor inconveniences but nothing which cannot be tackled.

    Anyhow, the answer you provided even being negative is the info I was looking for

    Thanks!


    We are also expecting that DateTime2 will be supported in future version program.
    Wednesday, June 23, 2010 1:59 PM
  • DATETIME doesn't work well with .NET applications in general since .NET System.DateTime objects accuracy is much higher than SQL Server's DATETIME. If you need indexing, or generally any comparison on a DATETIME column, other than doing strange rounding logic (which will not always work, either), you will have to use DATETIME2 for things to work correctly.

    Btw.

    What's the problem with supporting DATETIME2 in SqlSyncAdapter ?

    Tuesday, April 12, 2011 4:56 PM