Why is FORMAT function not recognised?

Question

I have executed the following query:

SELECT productid,
FORMAT(productid, 'd10') AS str_productid
FROM Production.Products;

I it is sayng that 'FORMAT' is not a recognized built-in function name. I am using the TSQL2012 database and Microsoft SQL Server 2012 Express. Can some one tell me what is wrong? The Express verssion has not included Format function?

probably there are problems with installation or you don't have enough access to system databases — user1455836, Jan 16 '14 at 11:05
It is possible, because I have seen that `SYSDATETIME` is not recognised too. How to fix this? — thedarkside ofthemoon, Jan 16 '14 at 11:10
what does this select compatibility_level, name from sys.databases command output? — user1455836, Jan 16 '14 at 11:18

score 1 · Accepted Answer · answered Jan 16 '14 at 11:24

1

Try this

ALTER DATABASE database_name 
SET COMPATIBILITY_LEVEL = 110

here are details

answered Jan 16 '14 at 11:24

user1455836

752
6
18

It does not allow that, the maximum is 90, is there another method? Reinstalling or something like this? – thedarkside ofthemoon Jan 16 '14 at 11:30
I have found it: I was connected on an old server. Just switch the servers and it is ok. – thedarkside ofthemoon Jan 16 '14 at 12:21

Why is FORMAT function not recognised?

1 Answers1