How to add 30 days to existing date

Question

If a member signs into my site then on sql it inserts the members name , password , date as now().
I created another item on my table called datetr. I want it must calculate +30days from the actual date they sign in (now()) and update the datetr.

Basically I am giving them a 30 day trial and then they need to be blocked if they have not paid.
Maybe you have a better idea to do this.

Hemant Srivastava · Answer

try this one it should work: $sql_insert = INSERT into `users` (`full_name``user_email``pwd``date``datetr``users_ip``activation_code``user_name` ) VALUES ('$data[full_name]''$usr_email''$sha1pass' GETDATE() GETDATE() +30 '$user_ip''$activ_code''$user_name' ) ; If it helps you pls mark it accepted.

shabeer shaik · Answer

$sql_insert = INSERT into `users` (`full_name``user_email``pwd``date``datetr``users_ip``activation_code``user_name` ) VALUES ('$data[full_name]''$usr_email''$sha1pass'now()now().AddDays(30)'$user_ip''$activ_code''$user_name' ) ; How do i use it here

Santhosh Kumar Jayaraman · Answer

you can use DateAdd function DATEADD ( dd  30  getdate() ) This will add 30 days to current date