I use datepickers a lot in my projects the date’s default to the American YYYY-MM-DD format so they store in the database, the trouble is my clients are UK based so it’s not very readable. The datepickers let you set the format you want so I use DD-MM-YYYY.
That’s great until it needs to go into a MySQL database then I need the former date. As I know what the format will always be using strtotime makes it easy to convert like this:
$date = '26-07-2016';
echo date("Y-m-d",strtotime($date));
Using date specify the format desired then pass in strtotime with the date to be formatted.
This is a very easy method, works with times too.
0 comments
Add a comment