[RESOLVED] Why is there different function in SQL Server and SQL management studio (SSMS) 2017 ?

[Macronaute]

Hi, I think I understood the difference between SQL Server and SSMS (at least, I have an idea).

I'm using SSMS and I wanted to compare two dates. I try to use functions like "NOW()" ; "DATE()" but it doesn't work on SSMS.

Finally I succeed to do what I wanted using DATEDIFF() :

Select datediff(DAY, @Year-@Month-@Day, 2015-11-11)

But I was wondering why we can't use SQL Server's function in SSMS, is there someone who could enlighten me ?