VB.net mySQL How to use DateAdd in sql query

Question

I'm getting an error when the form load and it said FUNCTION databasename.DateAdd does not exist

con.Open()
cmd.Connection = con
cmd.CommandText = "update pawn set status = 'Renewed', date_added = DateAdd(month,4,date_added), first_date = DateAdd(month,5,first_date), second_date = DateAdd(month,6,second_date), due_date = DateAdd(month,7,due_date)"
dr = cmd.ExecuteReader
con.Close()

Check MySQL's Date_add() function

Vivek S.
– Vivek S.

2016-02-08 05:23:05 +00:00
Commented Feb 8, 2016 at 5:23 — Vivek S.
– Vivek S., Commented Feb 8, 2016 at 5:23

Vivek S. · Accepted Answer · 2016-02-08 05:33:43Z

1

You've used VB.NET's DateAdd() inside the query which won't work for MySQL because MySQL doesn't has an inbuilt function like that

Syntax for MySQL date add function is DATE_ADD(date,INTERVAL expr type)

   cmd.CommandText = "update pawn set status = 'Renewed' " & _
                     ",date_added = DATE_ADD(date_added,INTERVAL 4 MONTH)" & _
                     ",first_date = DATE_ADD(first_date,INTERVAL 5 MONTH)" & _
                     ",second_date = DATE_ADD(second_date,INTERVAL 6 MONTH)" & _
                     ",due_date = DATE_ADD(due_date,INTERVAL 7 MONTH)"

edited Feb 8, 2016 at 5:33

answered Feb 8, 2016 at 5:28

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

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

Comments

Zafar Malik · Accepted Answer · 2016-02-08 05:29:50Z

1

You can do something like below-

ADDDATE(date_column, INTERVAL 4 YEAR)
ADDDATE(date_column, INTERVAL 4 MONTH)
ADDDATE(date_column, INTERVAL 4 DAY)

answered Feb 8, 2016 at 5:29

Zafar Malik

6,8723 gold badges23 silver badges31 bronze badges

Collectives™ on Stack Overflow

VB.net mySQL How to use DateAdd in sql query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related