tjrobinson.net

Home

❯

Conversion failed when converting date and or time from character string

Conversion failed when converting date and or time from character string

Jul 07, 20261 min read

  • sql-server
SELECT COUNT(*)
FROM [vwTasks] AS [item]
WHERE ((([item].[Deadline] < '2019-04-15T00:00:00.0000000')

Conversion failed when converting date and/or time from character string

This can happen when Entity Framework Core generates datetime2-style literals for a column that is datetime.

  • EF Core 2.0: default all date fields to use datetime2 — Stack Overflow
  • Data types — EF Core relational modelling docs

See also

  • SQL Server

Related bookmarks (27)

  • Jerry Nixon on SQL Server Extension for VS Code [EPISODE 857]youtube.com · Jul 18, 2025
  • Turn your .NET CLI tool into a local MCP Server for use with GitHub Copilot in VS Codeerikej.github.io · May 14, 2025
  • Packaging Permissions in Stored Proceduressommarskog.se · Feb 28, 2025
  • Introducing MSBuild.Sdk.SqlProj 3.0 - create, build, validate, analyze, pack and deploy SQL database projects with .NET 9erikej.github.io · Jan 24, 2025
  • Deploying .dapacs to Azure SQL via Azure DevOps Pipelinestechcommunity.microsoft.com · Sep 30, 2024
  • Migrating an Azure SQL DB to a SQL MI by utilizing SqlPackage/ADFtechcommunity.microsoft.com · May 11, 2024
  • Getting Started with SMO in SQL 2005 - Restoressqldbatips.com · Apr 05, 2016
  • Backup and restore SQL databases (C# Programming Tutorial)geekpedia.com · Apr 05, 2016
  • Changing the default SQL Server backup foldermssqltips.com · Apr 05, 2016
  • Dylan Beattie: The Mysterious Case of the Latin General: Collations in SQL Serverdylanbeattie.net · Apr 05, 2016
  • SQL Server Common Table Expressionsblackwasp.co.uk · Apr 05, 2016
  • sqlbits.com/sqlbits.com · Apr 05, 2016
  • serverfault.com/questions/.../installing-sql-server-2008-on-windows-7-64-b...serverfault.com · Apr 05, 2016
  • blogs.msdn.com/b/.../2011/.../introducing-localdb-a-better-sql-...blogs.msdn.com · Apr 05, 2016
  • Hierarchies with HierarchyID in SQL 2008blogs.msdn.com · Apr 05, 2016
  • Best Practices for Creating Indexessqlserverpedia.com · Apr 05, 2016
  • Tally OH! An Improved SQL 8K “CSV Splitter” Functionsqlservercentral.com · Apr 05, 2016
  • A thorough Introduction to Integration Servicesdotnetstories.wordpress.com · Apr 05, 2016
  • How to use reserved words in MSSQLsqlhacks.com · Apr 05, 2016
  • SSMS Tools Packssmstoolspack.com · Apr 05, 2016
  • Microsoft SQL Server Version Listsqlserverbuilds.blogspot.co.uk · Apr 05, 2016
  • sp_BlitzCache™: Free SQL Server Plan Cache Analysis Script - Brent Ozar Unlimited® by Brent Ozar Unlimited®brentozar.com · Apr 05, 2016
  • Primeworks Data Port Wizardprimeworks-mobile.com · Apr 05, 2016
  • Idera SQL Server Free Toolsidera.com · Apr 05, 2016
  • Download SQL Server Management Studiomsdn.microsoft.com · Apr 05, 2016
  • SQL Server 2005 Xml Parameter Sizedevnewsgroups.net · Apr 05, 2016
  • Tibor Karaszi's SQL Server pageskaraszi.com · Apr 05, 2016

Graph View

  • Conversion failed when converting date and/or time from character string
  • See also

Backlinks

  • SQL Server