I want to read the string of text file date into the database, how to achieve it? Thank you !!!!

eyesfish

a.txt
20161018081240
.....
tb
theDateTime
2016-10-18 08:12

How can it be inserted into the time, the other formats are no problem, and no error is reported after becoming the date, just no data!
Thank you!!

yjycoral

The stored procedure defines the incoming parameters as DATETIME type, the characters will be converted to DATETIME type by default

苹果小刀

Add the delimiter to the string read from the database (such as 20161018081240), and then you can insert
20161018081240－》 2016-10-18 08:12:40

bastard

LZ means to put 20161018081240
Is this date and time format written into the database converted to 2016-10-18 08:12:40?

ryd1986

cast ('20161018081240' as datetime) can be used directly in the database. As long as your string is in the correct format

eyesfish

bastard
 
 
   LZ means to put 20161018081240
Is this date and time format written in the database on 2016-10-18 08:12:40?


  
 
Yes

eyesfish

It turns out that adding-:: would be foolish, just learning .... don't laugh