Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Msg 241, Level 16, State 1, Line 12 Conversion failed when converting date and/or time from character string.

DECLARE @Value nVarchar(MAX)='2016-03-01 00:00:00.000000'
SELECT CONVERT(DATETIME,LEFT(@Value,23),101)
Comment

PREVIOUS NEXT
Code Example
Sql :: sql count number of rows after group by 
Sql :: mysql copy table to another table 
Sql :: oracle add time to date 
Sql :: sql any 
Sql :: postgresql connection string c# 
Sql :: mysql connection w3 
Sql :: oracle apex warn on unsaved changes 
Sql :: sql all columns 
Sql :: view databases in mysql 
Sql :: SQL NOT BETWEEN Operator 
Sql :: sql remove decimal places 
Sql :: use group_concat in concat 
Sql :: how to enable extension in postgreSQL 
Sql :: multiple like in sql 
Sql :: db.relationship sqlalchemy flask 
Sql :: mysql get last inserted id 
Sql :: sql server insert into table 
Sql :: stored procedure to delete data from table in mysql 
Sql :: how to get 30 days previous date in mysql 
Sql :: between sql server 
Sql :: insert array postgresql 
Sql :: sql value exists in column 
Sql :: sql cast 
Sql :: how to change db owner postgres 
Sql :: postgres update single column 
Sql :: export mysql db using command line 
Sql :: oracle insert into where 
Sql :: drop function in sql 
Sql :: alter table primary key postgresql 
Sql :: sql server delete table 
ADD CONTENT
Topic
Content
Source link
Name
4+6 =