adding 30 minutes to datetime php/mysql

by

If you are using MySQL you can do it like this: 

SELECT '2008-12-31 23:59:59' + INTERVAL 30 MINUTE;

For a pure PHP solution use strtotime

strtotime('+ 30 minute',$yourdate);

More Related Contents:

  1. PHP DateTime supported formats
  2. timestamp within a form [closed]
  3. Php date() Date and time is stuck [closed]
  4. PHP 01/01/1970 Issues with Date Fields
  5. Convert from MySQL datetime to another format with PHP
  6. How to store repeating dates keeping in mind Daylight Savings Time
  7. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  8. Object of class DateTime could not be converted to string
  9. Simplest way to increment a date in PHP?
  10. How to store NULL values in datetime fields in MySQL?
  11. How to separate DATE and TIME from DATETIME in MySQL?
  12. PHP, MySQL and Time Zones
  13. Set timezone in PHP and MySQL
  14. PHP, Get tomorrows date from date
  15. php strtotime “last monday” if today is monday?
  16. How to convert ISO8601 to Date format in php
  17. PHP: strtotime is returning false for a future date?
  18. Date in a URL dd/mm/yyyy
  19. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  20. Using MySQL’s TIMESTAMP vs storing timestamps directly
  21. adding 1 day to a DATETIME format value
  22. Getting first weekday in a month with strtotime
  23. Determine If Business Is Open/Closed Based On Business Hours
  24. MySQL – ignore insert error: duplicate entry
  25. How to find day of week in php in a specific timezone
  26. “slash before every quote” problem [duplicate]
  27. How to store the data in unicode in hindi language
  28. PDO + MySQL and broken UTF-8 encoding
  29. Mysql password expired. Can’t connect
  30. mysql_connect VS mysql_pconnect [closed]

Leave a Comment