Error converting date to SQL statement

-4

I get this error

  

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

When executing the following query:

Select TOP 1 T2.Text12 AS DPI, 
             T2.Name AS NAME, 
             DATEADD(minute,-T1.MessageLocaleOffset,T1.MessageUTC) AS HORA_GMT 
FROM ACVSUJournal_00010002.dbo.ACVSUJournalLog T1 
JOIN ACVSCore.Access.Personnel T2 
ON T1.ObjectName1 = T2.Name  
WHERE T1.MessageType = 'CardAdmitted' 
  AND T1.ObjectName2 = 'APMTQ_E1' 
  AND DATEADD(minute,-T1.MessageLocaleOffset,T1.MessageUTC) > '{0}' 
ORDER BY T1.MessageUTC desc
    
asked by Victor 31.12.2018 в 10:41
source

0 answers