Format() function doesn't work?

Viewed 53802

I am trying to execute following built-in function in sql but it gives me error that this function doesn't exist

my query:

select EmpId, EmpName, format(EmpJoinDate, "YYYY-DD-MM") as date from Employee

Error i am getting:

'format' is not a recognized built-in function name

What may be the problem, or what am i doing wrong?

Thanks!

4 Answers
Related