Help..

[krappleby]

Hi all,

im not a proffessional programmer (or speller for that matter) but i do do quite a lot of programming for friends and family, one of the main things i always have problem with is times and dates..

here is my problem.

i have a date/time field in a mysql database, which i need to pull..

i do so and have the result say

1976/06/23 00:00:00

now.. i need to add 1 month to that date.. i have tried allsorts, to do this, but fail every time..

in my last attempt, i took todays date, added one month and ended up with a date about 33 years ago.

can someone please explain as to how i do this. i have checked the php manual but it only tells you how to allocate 1 month to the date() function, and not to a pulled mysql db record..

for arguments sake,. lets say the variable that holds the date is

$newdate

any help would be appreciated..
tahnks

 

[feherke]

Hi

If you not need that date for other operations, then better alter it in the MySQL [tt]select[/tt], using the [tt]adddate()[/tt] function.

If you want more help, post your code which queries, fetches, processes that date value.

Feherke.

http://free.rootshell.be/~feherke/

 

[krappleby]

thanks for the info. i have read the page to do with this.. but still not doing it right..

here is the mysql code

update DOWNLINES set MEMBER_ID = '" . $new_np . "', NP_REG_DATE = '" . $newdate . "', MAINT_DATE = DATE_ADD('" . $new_np_date2 . "', INTERVAL 1 MONTH), where UNIQUECODE = '" . $memid . "'

any ideas

thanks for the help

 

[feherke]

Hi

If you want our help, post relevant code. Cutting off a piece from the middle of a line is not relevant.

Also specify what is the exact value of the $new_np_date2 variable.

Feherke.

http://free.rootshell.be/~feherke/

 

[krappleby]

i havent cut anything off the middle of the code. lol.
from your statement there is a load missing.. ok..

i am not very experianced with mysql statements..
and the $new_np_date2 variable is

2009/12/30

 

[krappleby]

in the case above.. the variable is just passed, via a form..

 

[krappleby]

all i am trying to do is i have a form, where someone enters a date, say 30/12/2009

the form is processed and the date is formatted to

2009/12/30 as per the timedate in a database
i then process that to add 00:00:00

now.. the field $new_np_date2 contains only 2009/12/30

i need to add 1 month to that date.

simple

 

[spamjim]

http://www.vision.to/how-to-add-days-weeks-months-to-any-date-.php

or...

I may be "old school" (or "wrong school") but I like to use unix timestamps in databases where I need to do a lot of calculations based on time. If I need to add 30 days to a unix timestamp, I add '2592000' (30 days x 24 hours x 60 minutes x 60 seconds).

 

[feherke]

Hi

but I like to use unix timestamps in databases where I need to do a lot of calculations based on time.

That is the best choice when you have nothing suitable for date/time handling. SQL database servers usually have a special data type, the [tt]interval[/tt], and a lot of functions and operators to perform calculations. Letting the SQL server to calculate has the benefit of handling timezone and daylight saving differences too.


Feherke.

http://free.rootshell.be/~feherke/

 

[jpadie]

@OP

echo date('Y-m-j h:i:s', strtotime('+1 month', strtotime('2009/12/30')));

or something like that. (for a php solution as opposed to mysql).

 

[Hozzer]

Not sure why you'd be trying to accomplish this with mySQL... couldn't you just grab the time from the server serving up the sign up page?
Keeping in mind that by default the month January will actually equal 0 instead of 1.

I recently built something in ActionScript that captured local machine time and had to reformat the date / time to make it decipherable when generating reports.
i.e 1/0/2010 now reads 01/01/2010 in this structure day/month/year.

I have some code examples but again they are in ActionScript not php so I won't post it here.