Datetime Function

slevytam

Hello,

I have a datetime field (2003-02-09 03:28:44) and am looking to increment the date by exactly one month.

Does any have a function to do this?

If not, could you give me some advice how it could be done easily.

Thank you,

--SL

cgraz

Try

$query = mysql_query("UPDATE your_table SET field_name = '(field_name + INTERVAL 1 MONTH)' WHERE id='$id'");

Cgraz

slevytam

Hello,

Thanks for your reply,

Could you just help with some syntax.

Heres what I have:

$createDate=date("y-m-d g:i:s");

$sql="INSERT INTO userssubscription SET
createDate='$createDate',

expireDate='($createDate + INTERVAL 1 MONTH)'";

This doesn't seem to work.

Thanks again,

--SL

cgraz

Your'e using an INSERT, the code I gave you was for an UPDATE. INSERTs don't use SET, UPDATEs do.

$sql="INSERT INTO userssubscription (createDate, expireDate) VALUES('$createDate', '($createDate + INTERVAL 1 MONTH)')";

Cgraz

slevytam

Sorry to bother; but, how is this any different then what I have?

--SL

slevytam

Thanks alot for your help,

I believe the syntax was just a bit off

Solution:

$sql="INSERT INTO userssubscription SET
createDate='$createDate',
expireDate='$createDate' + INTERVAL 1 MONTH";

rcmehta_14

Don't use any kind of mysql code with getting date after 1 month. Instead use PHP mktime with date to solve ur problem. The syntax is like this:

$desiredDate = date("m-d-y", mktime(hh, mm, ss, month + 1, day, year));

where "m-d-y" - is the format that u want.
hh - is the hour part of ur original date field
mm- is the minute part of ur original date field.
ss- is the second part of ..............
month - is the month of ur original date field. and plus 1 will give u desire date that u want.

day - is the day part............
year is a 4 digit year of ur original date.

It is very powerful and don't waste ur useful resources to execute a query

planetsim

Theres my favourite

date("h:i:sa", strtotime("+1 Month"));