Urgent urgent, message 241, level 16, state 1, line 1 from a string when converting date and/or time-CodePudding

Home > database > Urgent urgent, message 241, level 16, state 1, line 1 from a string when converting date and/or time

Urgent urgent, message 241, level 16, state 1, line 1 from a string when converting date and/or time

Time：11-27

CodePudding user response:

 
Replace - the date of the month, and then press 105 (day - on - year) convert the format of date 
SELECT the CONVERT (DATE, and REPLACE (' 2 - January - 2020 ', 'month', '), 105)

CodePudding user response:

SQL server put the string into a date/time, want to use the convert function
-
Date of the place, therefore, to write the convert (datetime, '2020-11-26')

The oracle database to use to_date function,

Page link：https//www.codepudding.com/database/88292.html

Prev:How long/mysql query time interval between the longest

Next:SQL SEVER 2008 R2, I made an automatic backup job failure

Tags：

The base class

Links：
CodePudding