Unable to use SQL basic functions

Username (e.g. epiz_XXX) or Website URL

reventabilbao.ml

Error Message

execute command denied to user 'epiz_30653039'@'192.168.%' for routine 'epiz_30653039_RV.GETDATE'

Other Information

I´m unable to use this command, or any other, like DATEADD(), or any others. Is this a limitation of the free hosting, or am I doing something wrong?

As far as I know, GETDATE isn’t a MySQL function. If you want to get the current time, you can use CURDATE function. GETDATE is a Microsoft SQL Server function, as far as I can tell.

And because of this, MySQL assumes that GETDATE is a custom function you set on your own database, and we don’t support custom functions. Which is why it says for routine 'epiz_30653039_RV.GETDATE'.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.