How do I get next month date from today s date and insert it in my database

Question

I have two columns in my db  start date and end date  which are both DATE types  My code is updating the dates as follows    today date   date  Y-m-d     end date   date  Y-m-d       date  1 month      sql1    UPDATE  users  SET  start date        today date      end date        end date     WHERE  users   id       id    LIMIT 1       What is the best way to make  end date equal to  start date   one month  For example  2000-10-01 would become 2000-11-01

User · Answer

one way of doing this is- first getting last date of current month and then adding 1 day to it  to get next month s first date  This will prevent us from unintentional skipping of months which occurs while using   1 month    today date   date  quot Y-m-d quot      last date of month date  Y-m-t  strtotime  today date    get last date of current month  last day of month proper  strtotime  last day of month    new date date  Y-m-d   strtotime   1 day   last day of month proper     echo  new date

User · Answer

You can use PHP s strtotime   function      One month from today  date   date  Y-m-d   strtotime   1 month         One month from a specific date  date   date  Y-m-d   strtotime   1 month   strtotime  2015-01-01        Just note that  1 month is not always calculated intuitively  It appears to always add the number of days that exist in the current month   Current Date     1 month ----------------------------------------------------- 2015-01-01      2015-02-01     31 days  2015-01-15      2015-02-15     31 days  2015-01-30      2015-03-02     31 days  skips Feb  2015-01-31      2015-03-03     31 days  skips Feb  2015-02-15      2015-03-15     28 days  2015-03-31      2015-05-01     31 days  skips April  2015-12-31      2016-01-31     31 days    Some other date time intervals that you can use    date   date  Y-m-d       Initial date string to use in calculation   date   date  Y-m-d   strtotime   1 day   strtotime  date      date   date  Y-m-d   strtotime   1 week   strtotime  date      date   date  Y-m-d   strtotime   2 week   strtotime  date      date   date  Y-m-d   strtotime   1 month   strtotime  date      date   date  Y-m-d   strtotime   30 days   strtotime  date

User · Answer

01-Feb-2014       date   mktime  0  0  0  2  1  2014     echo strftime    d  B  Y   strtotime    1 month    date

User · Answer

The accepted answer works only if you want exactly 31 days later  That means if you are using the date  2013-05-31  that you expect to not be in June which is not what I wanted   If you want to have the next month  I suggest you to use the current year and month but keep using the 1st    date   date  Y-m-01     newdate   strtotime     1 month    strtotime    date         This way  you will be able to get the month and year of the next month without having a month skipped

User · Answer

If you want a specific date in next month  you can do this      Calculate the timestamp  expire   strtotime  first day of  1 month        Format the timestamp as a string echo date  m d Y    expire     Note that this actually works more reliably where  1 month can be confusing  For example     Current Day     first day of  1 month        1 month --------------------------------------------------------------------------- 2015-01-01      2015-02-01                  2015-02-01 2015-01-30      2015-02-01                  2015-03-02   skips Feb  2015-01-31      2015-02-01                  2015-03-03   skips Feb  2015-03-31      2015-04-01                  2015-05-01   skips April  2015-12-31      2016-01-01                  2016-01-31

User · Answer

nextm   date  m   strtotime   1 month   strtotime date  Y-m-01

User · Answer

Adding my solution here  as this is the thread that comes in google search  This is to get the next date of month  fixing any skips  keeping the next date within next month    PHP adds current months total number of days to current date  if you do  1 month for example    So applying  1 month to 30-01-2016 will return 02-03-2016   Adding 31 days   For my case  I needed to get 28-02-2016  so as to keep it within next month  In such cases you can use the solution below   This code will identify if the given date s day is greater than next month s total days  If so It will subtract the days smartly and return the date within the month range   Do note the return value is in timestamp format   function getExactDateAfterMonths  timestamp   months        day current date              date  d    timestamp        first date of current month   date  01-m-Y    timestamp           t  gives last day of month  which is equal to no of days      days in next month            date  t    strtotime      months   months   strtotime  first date of current month           days to substract   0      if  day current date  gt   days in next month            days to substract    day current date -  days in next month        php date after months     strtotime      months   months    timestamp        exact date after months   strtotime  -   days to substract   days    php date after months        return  exact date after months     getExactDateAfterMonths strtotime  30-01-2016    1       php date after months     gt  02-03-2016     exact date after months   gt  28-02-2016

User · Answer

date  Y-m-d  strtotime  last day of  1 month  strtotime  anydate

User · Answer

This function returns any correct number of months positively or negatively  Found in the comment section here   function addMonthsToTime  numMonths   1   timeStamp   null        timeStamp     null and  timeStamp   time     Default to the present      newMonthNumDays    date  d  strtotime  last day of    numMonths   months    timeStamp     Number of days in the new month      currentDayOfMonth   date  d   timeStamp        if  currentDayOfMonth  gt   newMonthNumDays          newTimeStamp   strtotime  -    currentDayOfMonth -  newMonthNumDays    days    numMonths   months    timeStamp         else        newTimeStamp   strtotime  numMonths   months    timeStamp              return  newTimeStamp

User · Answer

Be careful  because sometimes strtotime   1 months   can skip month numbers   Example    today   date  Y-m-d       2012-01-30  next month   date  Y-m-d   strtotime   today  1 month       If today is January  next month should be February which has 28 or 29 days  but PHP will return March as next month  not February

User · Answer

You can use strtotime   as in Gazler s example  which is great for this case   If you need more complicated control use mktime      end date   mktime date  H    date  i    date  s    date  n     1  date  j    date  Y

User · Answer

You do not actually need PHP functions to achieve this  You can already do simple date manipulations directly in SQL  for example    sql1         UPDATE  users  SET       start date    CURDATE          end date    DATE ADD CURDATE    INTERVAL 1 MONTH        WHERE  users   id          id            Refer to http   dev mysql com doc refman 5 1 en date-and-time-functions html function addtime

User · Answer

I know - sort of late  But I was working at the same problem  If a client buys a month of service  he she expects to end it a month later  Here s how I solved it        now   time          day   date  j   now        year   date  o   now        month   date  n   now        hour   date  G         minute   date  i         month     count      if   month  gt  12                        month -  12               year                        work   strtotime  year    -     month    -01         avail   date  t   work       if   day  gt   avail               day    avail       stamp   strtotime  year    -     month    -     day          hour          minute     This will calculate the exact day n count months from now  where count  lt   12   If the service started March 31  2019 and runs for 11 months  it will end on Feb 29  2020  If it runs for just one month  the end date is Apr 30  2019

User · Answer

I think this is similar to kouton s answer  but this one just takes in a timeStamp and returns a timestamp SOMEWHERE in the next month  You could use date  m    nextMonthDateN  from there    function nextMonthTimeStamp  curDateN        nextMonthDateN    curDateN     while  date  m    nextMonthDateN     date  m    curDateN            nextMonthDateN    60 60 24 27          return  nextMonthDateN    or return date  m    nextMonthDateN

[php] How do I get next month date from today's date and insert it in my database?

Examples related to php

Examples related to mysql

Examples related to date