Ok, I seen loooodes of threads on this elsewhere but no proper answer:
In a MySQL table there is a date in the format of yyyy-mm-dd. I want to add 30 days onto that. It qould probably be done by PHP, or my a MySQL table. But remember you must take into account the amount of days in each month etc. Its a hard problem to solve and as far as I've seen PHP or SQL dosn't have any functions to do it directly. Has anyone got any help at all?
I for one can't tell what you are asking. May be a reason why you have no replies. Are you saying the date was entered wrongly?
I'm using Windows 7 - you got a problem with that?
Just add 30 days worth in seconds:
30 days = 2, 592 ,000 seconds
Theres a mySQL function to do that.
Many thanks to egghead for the cool .sig
oh right, I couldn't find anything like that when I looked before but ill have another search later
$newdate = mktime(0, 0, 0, date("m") , date("d")+30, date("Y")); could solve your problem.
Hello jellewar
Thanks a lot for this posting. Iam still looking for some IDE to learn PHP programming. May be phpDesigner is the right one to start with.
HP
Posting Permissions
Reply With Quote
Bookmarks