PHP DateTime format using pre-existing data [duplicate]

Question

I have access to a set of date and times as so dd/mm/yy hh:mm so as an example 15/05/24 14:00, I am trying to set this to be an input for mySql DateTime format, however when I do it the system thinks the first number is the year not the last number.

Can I tell PHP that the initial date input was dd/mm/yy?

I have this setup to create the format for the DateTime but as I say its output is putting the first number as the year not the last.

$strtime[] = date("Y-m-d H:i:s", strtotime(str_replace('/', '-',$time)));

You can use DateTime, see: 3v4l.org/ZKqYi but several other solutions are possible. — KIKO Software
– KIKO Software, Commented May 22 at 17:47
@Nicolas Their format string is in the output function, not parsing. — Barmar
– Barmar, Commented May 22 at 17:48
See DateTime::createFromFormat(), which allows you to specify the format of the input. — Barmar
– Barmar, Commented May 22 at 17:49
Thank you very much KIKO Software, I didn't think of that method and It has worked perfectly thanks. — Chalkie
– Chalkie, Commented May 22 at 17:51

Solt · Accepted Answer · 2025-05-22 17:49:42Z

-2

Regexp solves everything!

<?php $time="15/05/24 14:00"; $sql_time=preg_replace('#^(\d+)/(\d+)/(\d+) (.*)$#','20$3-$2-$1 $4:00',$time); echo $sql_time; //2024-05-15 14:00:00

https://3v4l.org/nkD4n

answered May 22 at 17:49

Solt

1,5013 silver badges17 bronze badges

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

6 Comments

Barmar May 22 at 17:53

DateTime::createFromFormat() is a better solution.

Chalkie May 22 at 17:53

I appreciate that will create the answer, however the DateTime::createFromFormat() is the better method for me, plus it looks cleaner. Thanks though.

Solt May 22 at 18:02

Spend some time to learn regular expressions, they are really helpfull in many cases.

KIKO Software May 22 at 18:50

If your only tool is a hammer then every problem looks like a nail. But you're right, regular expressions can be useful. In this case however there is a more standard method to solve this problem.

Solt May 22 at 20:34

It is impossible to answer closed question. I answered before it. How could I know that it will be closed? Here are MILLIONS of people and you are again selecting me to downvote? Thanks a lot!

|

Collectives™ on Stack Overflow

PHP DateTime format using pre-existing data [duplicate]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related