DateValue Function missing in SQL Server 2012 Express

Question

DateValue Function missing in SQL Server 2012 Express

tonyevans

Old Hand

Points: 379
More actions
January 29, 2013 at 2:02 am

#273519

Hi All
I am trying to use the DateValue function on a table in SQL Server Express 2012 but it says that it is 'not a recognized built-in function name'. Has it been removed from the express version or have I done something wrong in the installation?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

DateValue is not SQL Server T-SQL function. It is a DAX one. You need SSAS in order to use it.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

tonyevans Old Hand Points: 379 More actions · Answer 2

Thanks SSCrazy, as express doesn't support SSAS I will have to do this a different way.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

You are welcome Forum Newbie

Such a strange nick name you have... :hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Ant-Green SSC Guru Points: 113536 More actions · Answer 4

Look at cast or convert using a date style http://msdn.microsoft.com/en-us/library/ms187928.aspx, style 100 or 109 may be the ones to go for.

tonyevans Old Hand Points: 379 More actions · Answer 5

Eugene

Message to self, 'Must read whats on screen before replying'

Anthony.

Thanks for the link will have a play.

DateValue Function missing in SQL Server 2012 Express

Cookies on SQLServerCentral