How can i get the date and add a month onto it so i can insert it into a database?
i need it becoz i am making a VIP system for my shop
Cheers.
i need it becoz i am making a VIP system for my shop
Cheers.
Date + Month
| DanielXP wrote: |
| How can i get the date and add a month onto it so i can insert it into a database?
i need it becoz i am making a VIP system for my shop
Cheers. |
You can just get the differences between 2 timestamps and calculate the difference between them.
Easiest (and best) way would be to do it on the database side:
mySQL has a whole range of date/time arithmetic functions, so, with a table "mytable" with a field "futuredate" of type "date", you'd do:
If you did that right now (and it's still June 8 where you are), the field would contain July 8, 2006. NOW() gets the current date, DATE_ADD() does date arithmetic for you.
If you mean 28 days or something like that, it would just require:
(yes, "DAY", not "DAYS")
The field would then contain "July 6, 2006".
etc.
You can obviously do it with datetime type too, if you need the exact time of day in addition to the day (i.e., July 8, 2006 21:52:00)
mySQL has a whole range of date/time arithmetic functions, so, with a table "mytable" with a field "futuredate" of type "date", you'd do:
| Code: |
| INSERT INTO mytable (futuredate) VALUES (DATE_ADD(NOW(), INTERVAL 1 MONTH)) |
If you did that right now (and it's still June 8 where you are), the field would contain July 8, 2006. NOW() gets the current date, DATE_ADD() does date arithmetic for you.
If you mean 28 days or something like that, it would just require:
| Code: |
| INSERT INTO mytable (futuredate) VALUES (DATE_ADD(NOW(), INTERVAL 28 DAY)) |
(yes, "DAY", not "DAYS")
The field would then contain "July 6, 2006".
etc.
You can obviously do it with datetime type too, if you need the exact time of day in addition to the day (i.e., July 8, 2006 21:52:00)
Just need 1 month so will
add on a month and put it into the database?
| Code: |
| INSERT INTO mytable (futuredate) VALUES (DATE_ADD(NOW(), INTERVAL 1 MONTH)) |
add on a month and put it into the database?
| DanielXP wrote: | ||
Just need 1 month so will
add on a month and put it into the database? |
It will add 1 month to the current date, and store the value in the field "futuredate", yes.
Hey can we get the difference of two dates ??
Eg. Difference between June 2 2006 and June 24 2006 is 22 days.
Such kind of thing.
Can be PHP ot MySql
Eg. Difference between June 2 2006 and June 24 2006 is 22 days.
Such kind of thing.
Can be PHP ot MySql
Yer i need the same thing so i can display there amount of days left
 |