All TagsTimeSQLServer2008 (RSS)
  • Inserting higher resolution dates into SQL Server 2008 datetime2 type

    I have some time data in logs with a sub-second time resolution. I can get this safely into log parser using the iTsFormat setting. When I put that into SQL Server 2008 I have (so far) gotten the times in seconds (loss of resolution). The target field is datetime2 (not datetime). How do I preserve the...
    Posted to Forum by MikeGale on 05-14-2009, 2:35 AM
Page 1 of 1 (1 items)
Microsoft Communities