Click here to Skip to main content
15,936,014 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQLite sqlite_schema missing Pin
Richard Deeming4-Jan-22 4:40
mveRichard Deeming4-Jan-22 4:40 
GeneralRe: SQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 7:16
_Flaviu4-Jan-22 7:16 
GeneralRe: SQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 7:17
_Flaviu4-Jan-22 7:17 
QuestionDate and Time Add Incompatibility between sql 2012 and sql 2018 Pin
Medo-I23-Dec-21 7:42
Medo-I23-Dec-21 7:42 
AnswerRe: Date and Time Add Incompatibility between sql 2012 and sql 2018 Pin
Richard Andrew x6423-Dec-21 8:56
professionalRichard Andrew x6423-Dec-21 8:56 
QuestionRe: Date and Time Add Incompatibility between sql 2012 and sql 2018 Pin
CHill6029-Dec-21 5:31
mveCHill6029-Dec-21 5:31 
AnswerRe: Date and Time Add Incompatibility between sql 2012 and sql 2018 Pin
jschell29-Dec-21 7:34
jschell29-Dec-21 7:34 
AnswerRe: Date and Time Add Incompatibility between sql 2012 and sql 2018 Pin
Richard Deeming4-Jan-22 0:44
mveRichard Deeming4-Jan-22 0:44 
Check your database compatibility level - it's likely that you had it set to 100 on your SQL Server 2012 instance, but it's set to 110 or higher on your SQL Server 2016/2019 instance.

(NB: There is no SQL Server 2018 version.)

As a temporary workaround, you may be able to set the compatibility level back to 100. But this will prevent you from using any features introduced after SQL Server 2008.

The correct fix would be to change your code to use DATEADD instead:
SQL
DATEADD(second, DATEDIFF(second, 0, SftpStartTime), shfts.Date) As SFtStartDateTime,




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

QuestionRoelf Pin
floris rudolf vieira22-Dec-21 6:58
floris rudolf vieira22-Dec-21 6:58 
AnswerRe: Roelf Pin
jschell23-Dec-21 6:12
jschell23-Dec-21 6:12 
AnswerRe: Roelf Pin
0x01AA5-Jan-22 4:44
mve0x01AA5-Jan-22 4:44 
QuestionSQL SERVER Pin
ali khan Dec202118-Dec-21 22:36
ali khan Dec202118-Dec-21 22:36 
AnswerRe: SQL SERVER Pin
Richard MacCutchan19-Dec-21 6:57
mveRichard MacCutchan19-Dec-21 6:57 
AnswerRe: SQL SERVER Pin
0x01AA5-Jan-22 4:46
mve0x01AA5-Jan-22 4:46 
Question2 queries from Oracle Pin
_Flaviu15-Dec-21 1:41
_Flaviu15-Dec-21 1:41 
AnswerRe: 2 queries from Oracle Pin
scottgp15-Dec-21 2:01
professionalscottgp15-Dec-21 2:01 
GeneralRe: 2 queries from Oracle Pin
_Flaviu15-Dec-21 2:41
_Flaviu15-Dec-21 2:41 
GeneralRe: 2 queries from Oracle Pin
scottgp15-Dec-21 3:05
professionalscottgp15-Dec-21 3:05 
QuestionHow does google classrooms classroom code works? Pin
Member 1546436511-Dec-21 19:43
Member 1546436511-Dec-21 19:43 
AnswerRe: How does google classrooms classroom code works? Pin
CHill6013-Dec-21 1:07
mveCHill6013-Dec-21 1:07 
QuestionData Warehouse vs Transaction Log tables Pin
Member 100956563-Dec-21 0:28
Member 100956563-Dec-21 0:28 
AnswerRe: Data Warehouse vs Transaction Log tables Pin
CHill606-Dec-21 6:46
mveCHill606-Dec-21 6:46 
GeneralRe: Data Warehouse vs Transaction Log tables Pin
Member 100956567-Dec-21 21:32
Member 100956567-Dec-21 21:32 
GeneralRe: Data Warehouse vs Transaction Log tables Pin
CHill607-Dec-21 21:57
mveCHill607-Dec-21 21:57 
AnswerRe: Data Warehouse vs Transaction Log tables Pin
Mycroft Holmes8-Dec-21 11:59
professionalMycroft Holmes8-Dec-21 11:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.