Auto increment datetime

Question

It is possible to auto-increment datetime which I parse from daterangepicker to add AddDays(7) and then insert it to DB?

string strValue = Page.Request.Form["daterange"];
string strValue2 = Page.Request.Form["daterange2"];

DateTime myDate = DateTime.Parse(strValue);
DateTime myDate2 = DateTime.Parse(strValue2);

queryStr = "INSERT INTO `wp_reservations` ( `arrival`, `departure`, `user`, `name`, `email`, `country`, `approve`, `room`, `roomnumber`, `number`, `childs`, `price`, `custom`, `customp`, `reservated`) VALUES ('" + strValue + "INTERVAL 7 DAY', '" + strValue2 + "', 0, '" + DropDownList1.SelectedItem.Text + "', '" + emailValue + "', 'SI', '" + DropDownList2.SelectedValue + "', '" + DropDownList3.SelectedValue + "', '1', 10, 0, '0;0', '', '', '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt") + "');";

https://msdn.microsoft.com/en-us/library/system.datetime.adddays(v=vs.110).aspx ? — SBI, Aug 13 '15 at 08:56
It's strange how you use the exact function syntax in your question... `myDate = myDate.AddDays(7);` — musefan, Aug 13 '15 at 08:56
...I suppose you also need to look at using the correct value in your query string, and you also need to research SQL injection and how to use SQL parameters — musefan, Aug 13 '15 at 09:00
@musefan Yeah i'm gonna use SQL parameters. Anyway i find solution for my problem. — Glados, Aug 13 '15 at 11:00
string test = DateTime.Parse(strValue).AddDays(7).ToString("yyyy-MM-dd HH:mm:ss tt"); — Glados, Aug 13 '15 at 11:00

er_chin · Answer 1 · 2015-08-13T10:23:37.083

1

You can use

DATE_ADD(NOW(), INTERVAL 7 DAY) in insert query

edited Aug 13 '15 at 10:23

answered Aug 13 '15 at 09:01

er_chin

21
3

score 0 · Answer 2 · edited May 23 '17 at 12:22

0

If u want to do this in code see Datetime in C# add days

U can also do it in DAO query see DATEADD (Transact-SQL)

edited May 23 '17 at 12:22

Community

1
1

answered Aug 13 '15 at 09:04

Esty

1,882
3
17
36

Auto increment datetime

2 Answers2