Date in a URL dd/mm/yyyy

by

When using strotime() you need to make sure you are using a valid datetime format. Otherwise strtotime() will return false or give you an unexpected value.

Dates that use XX/XX/XXXX format are assumed to be in US format which means the first two digits represent the month, the next two digits represent the day of month, and the last four digits represent the year. When dashes are used, the dates are assumed to be in European format. For example:

04/18/2017 = April 18, 2017
12/18/2017 = December 18, 2017
18-04-2017 = April 18, 2017
18-12-2017 = December 18, 2017

If you accidentally switch the day and month strtotime() will return false as the date is invalid.

18/04/2017 // error
18/12/2017 // error
04-18-2018 // error
12-18-2017 // error

The above examples are straight forward. But you can run into issues when the dates can be ambigous. For example:

04/12/2017 = April 12, 2017
12/04/2017 = December 4, 2017
04-12-2017 = December 4, 2017
12-04-2017 = April 12, 2017

In the above examples by switching the day and month we still get valid dates which can cause unexpected results in your application. To solve these potential issues it is recommended to use DateTime::createFromFormat() to parse the date ad return a DateTime() object from which you can get a Unix Timestamp, convert the date into another format, or use it to compare to other DateTime objects.

// Parse US date format
$date1 = DateTime::createFromFormat('m/d/Y', '04/18/2017');

// Get Unix timestamp of 1493581268
$timestamp = $date1->getTimestamp();

// Parse European date format
$date2 = DateTime::createFromFormat('d-m-Y', ''18-04-2017);

// Get MySQL format (ISO-8601) of 2017-04-18
$mysqlDate = $date2->format('Y-m-d');

See also:

For your specific case, the follow code will work:

$date = $date1 = DateTime::createFromFormat('m/d/Y', '20/02/2000');
$D->query = $date->format('Y-m-d'); // 2000-02-20

More Related Contents:

  1. Php date() Date and time is stuck [closed]
  2. Set timezone in PHP and MySQL
  3. How to convert ISO8601 to Date format in php
  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. PHP DateTime supported formats
  7. Display which day it is? sunday or monday “php coding”? [closed]
  8. PHP 01/01/1970 Issues with Date Fields
  9. Convert one date format into another in PHP
  10. Converting string to Date and DateTime
  11. Compare given date with today
  12. PHP DateTime::modify adding and subtracting months
  13. The first day of the current month in php using date_modify as DateTime object
  14. Calculate age based on date of birth
  15. Object of class DateTime could not be converted to string
  16. Find Month difference in php? [duplicate]
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. PHP, MySQL and Time Zones
  19. PHP order array by date? [duplicate]
  20. PHP, Get tomorrows date from date
  21. Calculate total seconds in PHP DateInterval
  22. How to display a date as iso 8601 format with PHP
  23. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  24. adding 30 minutes to datetime php/mysql
  25. Formatting an SQL timestamp with PHP
  26. MySQL, how to insert null dates
  27. Converting to date in PHP from yyyymmdd format
  28. Subtracting a certain number of hours, days, months or years from date
  29. How do I convert an ISO8601 date to another format in PHP?
  30. Determine If Business Is Open/Closed Based On Business Hours

Leave a Comment