mercredi 7 janvier 2015

'DateValue' is not a recognized built-in function name Sql Server 2005

What is the alternate of MS Access DateValue function in Sql Server Here is the Query



SELECT DISTINCT ss.FileName
FROM SubmitSheets AS ss
WHERE 1=1 AND 1=1 AND 1=1 AND
ss.UpdateTimeA >= DateValue('2014/11/03') AND
ss.UpdateTimeA < DateAdd("d", 1, DateValue('2016/01/06')) AND
(1=1) AND 1=1 ORDER BY ss.FileName


And Here is the Error



Msg 195, Level 15, State 10, Line 4
'DateValue' is not a recognized built-in function name.


This query works fine in MS Access


Aucun commentaire:

Enregistrer un commentaire