convert date format in php like 6th of November 2017 to 2017-11-6

Question

i want to convert a date format to another using php 6th of November 2017 to 2017-11-6

i tried

$newDate = date("Y-m-d", strtotime('6th of November 2017'));

but it always returns 01-01-1970

B. Desai · Answer 1 · 2017-11-08T06:55:32.727

4

When you create date from specific format then use createFromFormat of date.

$date = DateTime::createFromFormat('jS \o\f F Y', '6th of November 2017');
echo $date->format('Y-m-d');

Note: If you have string in your format then you have to escape that string (with \) for conversation

edited Nov 08 '17 at 06:55

answered Nov 08 '17 at 06:38

B. Desai

date("Y-m-d", strtotime("6th November 2017")) this is not working thats why i am asking – Uday Kumar Nov 08 '17 at 06:42
@B.Desai correct. I forgot that. already up-voted for your post – Alive to die - Anant Nov 08 '17 at 06:45
1

Your code is great ! but i come to one more problem when the date decreases or increases it changes like 1st 2nd 3rd then 4th after th is working but what when it is 1st 2nd or third ?? i did like this when creating the date $data[] = $date->format("jS \of F Y"); – Uday Kumar Nov 08 '17 at 06:47
2

Try updated code @UdayKumar change `\t\h` to `S` which will give you proper format – B. Desai Nov 08 '17 at 06:48
Thanks awesome ! – Uday Kumar Nov 08 '17 at 06:52

score 0 · Answer 2 · edited Nov 08 '17 at 09:23

0

Try this:

$newDate = date("Y-m-d", strtotime("6 November 2017"));

edited Nov 08 '17 at 09:23

B. Desai

answered Nov 08 '17 at 06:36

Ashish Tiwari

1

you changed the actual string . It's `6th of....` . so your code will not work. check here:- https://eval.in/895125 – Alive to die - Anant Nov 08 '17 at 06:44
OP itself stated that `$newDate = date("Y-m-d", strtotime('6th of November 2017'));` is not working – Alive to die - Anant Nov 08 '17 at 06:46
@Alive to Die yes but he is using `strtotime()` , to which he has provided invalid format which is `6th of November 2017` , it won't work. Hence i corrected above with proper format. – Ashish Tiwari Nov 08 '17 at 06:46
1

that's why he is asking a question that if format is not correct too, then how can he will go for correct solution. check other answer – Alive to die - Anant Nov 08 '17 at 06:47
Its upto him either he has to change function or he has to change format. – Ashish Tiwari Nov 08 '17 at 06:48

score 0 · Answer 3 · answered Nov 08 '17 at 07:12

0

Replace 6th of to 6th and it will be fine..

$newDate = date("Y-m-d", strtotime('6th November 2017'));
echo ($newDate);

result

2017-11-06

answered Nov 08 '17 at 07:12

Arbaz Khan

3 Answers3