Store timestamp with time 00:00:00

Question

I want to store a timestamp in the database with time component as 00:00:00.
The following code:

$start_date = Carbon::createFromFormat('d-m-Y', $date_interval["start_date"]); 
$end_date = Carbon::createFromFormat('d-m-Y', $date_interval["end_date"]);

adds the current time to the date, when I provide a date only without time specification.
I need this because I need to retrieve the internal integer from the database afterwards which should be the start of the day.

What is the best way to store this 'start of day'?

So you need a true 0 or an empty datetime like 0000-00-00 00:00:00? — Machavity
– Machavity ♦, Commented Dec 29, 2014 at 17:35
Why not just use a date field rather than a datetime/timestamp field? This field type does not have time component. — Mike Brant
– Mike Brant, Commented Dec 29, 2014 at 17:40
Have you tried: Carbon::createFromFormat('d-m-Y 00:00:00', ..); ;p — Lawrence Cherone
– Lawrence Cherone, Commented Dec 29, 2014 at 17:43
There's also the startOfDay() method that you can use to reset the date objects time to 00:00:00, once again in docs Ctrl-F with help you find it. — Lawrence Cherone
– Lawrence Cherone, Commented Dec 29, 2014 at 17:50

Abdalla Arbab · Accepted Answer · 2017-09-13 19:00:46Z

38

For safety just let Carbon decide the end or the start of the day using ->endOfDay() or ->startOfDay(). Choose what suits you more.

Carbon::createFromFormat('d-m-Y', $date_interval["start_date"])->endOfDay();
Carbon::createFromFormat('d-m-Y', $date_interval["start_date"])->startOfDay();

edited Sep 13, 2017 at 19:00

answered Aug 13, 2017 at 5:34

Abdalla Arbab

1,4103 gold badges25 silver badges33 bronze badges

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

1 Comment

Abdalla Arbab Over a year ago

@Trace is there any way my answer will be chosen, as it's more updated?

Alister Bulman · Accepted Answer · 2014-12-29 19:02:16Z

34

I've usually set the date with the call, and then reset the time to 00:00 with

Carbon::setTime(0, 0, 0);  // from the parent, DateTime class

In the class, there is also a Carbon::startOfDay() method that will set the appropriate values.

public function startOfDay()
{
    return $this->hour(0)->minute(0)->second(0);
}

answered Dec 29, 2014 at 19:02

Alister Bulman

35.3k9 gold badges75 silver badges113 bronze badges

2 Comments

Alister Bulman Over a year ago

As of v1.24.0, the Carbon library has also added createMidnightDate($year = null, $month = null, $day = null, $tz = null).

JCarlosR Over a year ago

In case we have a time field, we can set that directly calling setTimeFromTimeString from the Carbon instance.

HMD · Accepted Answer · 2019-11-27 15:03:06Z

2

Carbon::createFromFormat() differs from its parent, in that missing parts are set to the current date or time instead of zero. In order to make it behave like \DateTime::createFromFormat(), use the | or ! format characters, as described in the manual (https://www.php.net/manual/en/datetime.createfromformat.php).

Example:

$midnight = Carbon::createFromFormat(
    'Y-m-d|', // or: '!Y-m-d'
    $date
);

edited Nov 27, 2019 at 15:03

HMD

2,2256 gold badges30 silver badges40 bronze badges

answered Nov 27, 2019 at 14:41

Reto Kohli

313 bronze badges

1 Comment

Matt Inamdar Over a year ago

This is really useful, I was never aware of this!

unixmiah · Accepted Answer · 2014-12-29 17:39:33Z

0

You shouldn't do that.

set your start_date DATE NULL DEFAULT NULL`

You should let MySQL default to NULL not 0000-00-00

answered Dec 29, 2014 at 17:39

unixmiah

3,1631 gold badge16 silver badges27 bronze badges

2 Comments

Trace Over a year ago

I think that there is a misunderstanding... I'm not looking for a null value, rather a timestamp where the time is set to the start of the day 00-00-00.

unixmiah Over a year ago

then you should use $start_date = strtotime("midnight");

Collectives™ on Stack Overflow

Store timestamp with time 00:00:00

4 Answers 4

1 Comment

2 Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related