Write function from SQL Server into MySQL query?

Question

I have some problem to convert an SQL Server query into MySQL. In SQL Server, the function recognize as DATENAME() and I changed it into MONTHNAME(). Then dateadd() in SQL Server become date_add() function.

Some sample for SQL Server query is

DATENAME("month",DATEADD("month",1,'8/1/2006'))

As I mentioned above, the query works well in SQL Server but it's not working at MySQL.

Then I tried rewrite the function into like this

MONTHNAME("8/1/2006",DATE_ADD("8/1/2006", INTERVAL 1 month))

Once again, it nots working.

How to fix that?

No, I meant don't tag SQL Server because you are not looking for SQL Server experts, you are looking for MySQL experts. — Dale K
– Dale K, Commented Aug 29, 2022 at 4:09
What does MONTHNAME("8/1/2006",DATE_ADD("8/1/2006", INTERVAL 1 month)) give you and what do you want it to return? — Evert
– Evert, Commented Aug 29, 2022 at 4:10
#1582 - Incorrect parameter count in the call to native function 'MONTHNAME' — Rico Amanda
– Rico Amanda, Commented Aug 29, 2022 at 4:12

Rico Amanda · Accepted Answer · 2022-08-29 12:13:29Z

1

there is easy way to solve my problem.

i just rewrite it again from

MONTHNAME("8/1/2006",DATE_ADD("8/1/2006", INTERVAL 1 month))

into this

DATE_FORMAT(DATE_ADD("8/1/2006", INTERVAL 1 month), "%M")

this way, i get what i want

NOTE: THANKS FOR THE DOCUMENT MR P.SALMON

answered Aug 29, 2022 at 12:13

Rico Amanda

255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write function from SQL Server into MySQL query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related