laravel date time to date from mysql

Question

the date stored in mysql is in Datetime format 'Y-m-d H:m:s' using laravel eloquent I want to convert Datetime format to date 'Y-m-d' the date stored in mysql table is 2016-11-29 17:23:56 and in the controller to convert I am using the below

$currentdate = Carbon::createFromFormat("Y-m-d H:m:s",$token->IssueDate)->format("Y-m-d");

the result I am getting is "2017-11-29" another example

Mysql record stored date is 2016-12-01 17:27:47 and the result I am getting is "2018-03-01"

Please help what am I missing here.

I have a constructor in the controller

public function  __construct()
{
  date_default_timezone_set("Asia/Kolkata");
}

which I don't think is a pronblem as after removing I am still getting the same result.

aynber · Accepted Answer · 2016-12-01 18:03:37Z

1

m is month. You want i for minutes (documentation):

$currentdate = Carbon::createFromFormat("Y-m-d H:i:s",$token->IssueDate)->format("Y-m-d");

answered Dec 1, 2016 at 18:03

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

Comments

Martin S · Accepted Answer · 2016-12-01 18:05:40Z

1

Change Y-m-d H:m:s to Y-m-d H:i:s (i refers to minute, not m). More on manual.

answered Dec 1, 2016 at 18:05

Martin S

4283 silver badges12 bronze badges

Collectives™ on Stack Overflow

laravel date time to date from mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related