SQL Server Error: Conversion failed when converting datetime from character string

Question

392310201639i want to convert this varchar type date to datetime in format yyyymmdd in sql serverwhen i am trying its giving error Conversion failed when converting datetime from character string

pandeyism · Accepted Answer

Hi  iammannRefer below sample querySQLDECLARE TestDate AS TABLEDate VARCHAR10INSERT INTO TestDate VALUES392310201639SELECT CONVERTDATETIMEDate105 Date FROM TestDate

SQL Server Error: Conversion failed when converting datetime from character string

Company

Explore

Follow us

Contact Us