PHP Date Formats

Question

This should be simple, but I'm having trouble... so turn to StackOverflow...

I'm in the UK and am getting a date from the jQuery DatePicker in a dd/mm/yy format. I want to store this date as a serial (yyyymmdd) so run a Date_To_Serial function that just does:

return date("Ymd", strtotime($strDate_In));

where $strDate_In is the date string in dd/mm/yy format.

So, passing in 01/12/2013, I expect 20131201 to be returned.

But, when 01/12/2013 is passed in, it returns 20130112 - PHP obviously assumes the date format is mm/dd/yyyy.

How can I fix this please?

@JezB : Hello friend, date picker provide to set the format of date. So if you choose Ymd there then i think you will not get the problem again. Try it — Girish Kumar Sinha
– Girish Kumar Sinha, Commented Jan 24, 2014 at 11:27
@JezB : Please see jqueryui.com/resources/demos/datepicker/date-formats.html — Girish Kumar Sinha
– Girish Kumar Sinha, Commented Jan 24, 2014 at 11:32

Kasper Pedersen · Accepted Answer · 2014-01-24 11:23:12Z

5

If you know the format, try using the static createFromFormat method on the DateTime class:

$date = DateTime::createFromFormat('d/m/Y', '01/12/2013');
return $date->format('Ymd');

answered Jan 24, 2014 at 11:23

Kasper Pedersen

5163 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JezB Over a year ago

Thank you - I knew someone would know very quickly!

Community · Accepted Answer · 2023-11-17 20:24:57Z

1

If the separator is a / then strtotime assumes a US-format. To have it recognise a UK format the separator must be - or .:

echo date('Ymd', strtotime('01/12/2014')); // 20140112
echo date('Ymd', strtotime('01-12-2014')); // 20141201

So for this to work in your example you would do:

return date("Ymd", strtotime(str_replace('/', '-', $strDate_In)));

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Jan 24, 2014 at 11:33

Michael

12.9k6 gold badges57 silver badges69 bronze badges

1 Comment

JezB Over a year ago

"f the separator is a / then strtotime assumes a US-format. To have it recognise a UK format the separator must be - or .:" - I didn't know that... thanks!

Community · Accepted Answer · 2023-11-17 19:51:26Z

0

Use a DateTime object's createFromFormat method. It allows you to specify the format of the input.

Afterwards, use the format method to export the date in the desired format.

edited Nov 17, 2023 at 19:51

CommunityBot

11 silver badge

answered Jan 24, 2014 at 11:23

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

Comments

Maximilian Riegler · Accepted Answer · 2014-01-24 11:32:33Z

0

Check out DateTime::createFromFormat for correct handling of non-standard date formats.

return DateTime::createFromFormat("d/m/Y", $strDate_In)->format("Ymd");

answered Jan 24, 2014 at 11:32

Maximilian Riegler

23.6k4 gold badges65 silver badges73 bronze badges

Collectives™ on Stack Overflow

PHP Date Formats

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related