Php date() Date and time is stuck [closed]

by

mysql’s standard/native date format is yyyy-mm-dd hh:mm:ss. If you feed in anything else, mysql will interpret it as best it can, but will fail (as it is in your case). Don’t try to use another format. And what’s with all the explode stuff? If you want to manipulate the date variable, then don’t use all those round-trips from time->string->whatever->string->whatever->etc…

More Related Contents:

  1. Set timezone in PHP and MySQL
  2. How to convert ISO8601 to Date format in php
  3. Date in a URL dd/mm/yyyy
  4. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  5. adding 1 day to a DATETIME format value
  6. timestamp within a form [closed]
  7. PHP 01/01/1970 Issues with Date Fields
  8. How to store repeating dates keeping in mind Daylight Savings Time
  9. Correctly determine if date string is a valid date in that format
  10. PHP mysql insert date format
  11. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  12. Adding one day to a date
  13. Add ‘x’ number of hours to date
  14. The first day of the current month in php using date_modify as DateTime object
  15. Calculate age based on date of birth
  16. How can I check if the current date/time is past a set date/time?
  17. Simplest way to increment a date in PHP?
  18. How to generate random date between two dates using php?
  19. How to store NULL values in datetime fields in MySQL?
  20. How to separate DATE and TIME from DATETIME in MySQL?
  21. PHP order array by date? [duplicate]
  22. How do I find the hour difference between two dates in PHP?
  23. How to display a date as iso 8601 format with PHP
  24. How do you explain the result for a new \DateTime(‘0000-00-00 00:00:00’)?
  25. Using MySQL’s TIMESTAMP vs storing timestamps directly
  26. day of the week to day number (Monday = 1, Tuesday = 2)
  27. MySQL, how to insert null dates
  28. Converting to date in PHP from yyyymmdd format
  29. Subtracting a certain number of hours, days, months or years from date
  30. How do I convert an ISO8601 date to another format in PHP?

Leave a Comment