http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/SQL Server 2008 DateTime Formattinghttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/en-usFri, 31 Oct 2008 12:29:43 GMTFri, 31 Oct 2008 12:29:43 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)I was gonna say skip Linq to sql and jump to EF.<br><br>Linq to SQL is great, but limited, especially when it comes to schema changes...<br><br>http://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=437497Fri, 31 Oct 2008 12:29:42 GMThttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=4374970http://channel9.msdn.com/437497/WebViewBug.aspx?EVT=0I was gonna say skip Linq to sql and jump to EF.Linq to SQL is great, but limited, especially when it comes to schema changes...John0http://channel9.msdn.com/437497/Trackback.aspxOK, a moot point now that <A href="http://blogs.msdn.com/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx">Linq to SQL is effectively sidelined by Microsoft</A>&nbsp;so I won't be pitting any more effort into trying it out ... Entity Framework, here I come!<BR><BR><BR>Herbie<BR>http://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=437492Fri, 31 Oct 2008 11:52:21 GMThttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=4374920http://channel9.msdn.com/437492/WebViewBug.aspx?EVT=0OK, a moot point now that Linq to SQL is effectively sidelined by Microsoft&nbsp;so I won't be pitting any more effort into trying it out ... Entity Framework, here I come!HerbieHerbie Smith0http://channel9.msdn.com/437492/Trackback.aspxI believe you have to use the new SQL Server 2008 DATETIME2 data type which supports a larger precision,&nbsp;00:00:00 through 23:59:59.9999999.<BR><BR>Rojhttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=437477Fri, 31 Oct 2008 10:36:08 GMThttp://channel9.msdn.com/forums/TechOff/437223-SQL-Server-2008-DateTime-Formatting/?CommentID=4374770http://channel9.msdn.com/437477/WebViewBug.aspx?EVT=0I believe you have to use the new SQL Server 2008 DATETIME2 data type which supports a larger precision,&nbsp;00:00:00 through 23:59:59.9999999.RojRoj0http://channel9.msdn.com/437477/Trackback.aspx