Current date with datetime

Question

I have a vacation request form, I have a two date and time fields. Well one field is start_date and another is end_date. What I want is that when a user goes to create a request, in the field of start_date leave the current date and the time is 08:00, some help?

It should look like this:

Start Date: 28/02/2017 08:00

In the database is also as DATETIME

How are you executing the query? Are you wanting to set that datetime in PHP and pass it as a parameter, or to do it in the query? — Don't Panic, Feb 28 '18 at 18:31

RDev · Accepted Answer · 2018-02-28T19:00:54.950

2

You can set time of any DateTime object with this method:

$start_date = (new DateTime)->setTime(8,0)->format('d/m/Y H:i');

Or if you are pulling the datetime from database as string:

$start_date = DateTime::createFromFormat('Y-m-d H:i:s', $yourDateTime)
                  ->setTime(8,0)
                  ->format('d/m/Y H:i');

edited Feb 28 '18 at 19:00

answered Feb 28 '18 at 18:32

RDev

1,221
1
12
17

Yes! Works! but what if I want the current date and time? – xerox_12 Feb 28 '18 at 18:51
@AlvaroRomanFranco if you want the current date and current time, just remove the `->setTime()` method from the first example – RDev Feb 28 '18 at 18:55

Current date with datetime

1 Answers1