How can I format separate date and time variables in Laravel

Question

I have a $date and $time fields that are stored in my db, I would like to know how can I format these fields to display them in a different format?

e.g.

2010-05-09 -> 9th May 2010

and

13:00:00 -> 1:00PM

I have tried to use carbon but it returns the following error:

InvalidArgumentException in Carbon.php line 414: Unexpected data found. Data missing

Just use Carbon, Laravel doesn't have any special classes or helpers to deal with dates — Mohamed Bouallegue, Oct 04 '15 at 01:38

score 1 · Answer 1 · answered Oct 04 '15 at 01:49

1

You can always use PHP's strtotime() function and then manipulate the structure using date() as seen below.

$dateString = strtotime("2010-05-09");
$date = date("jS F, Y" ,$dateString);
echo $date;

$timeString = strtotime("13:00:00");
$time = date("g:i A" ,$timeString);
echo $time;

FWIW, I didn't realize you said specifically in Laravel. But I typed it all out, so figured I'd share anyways. Carbon (as mentioned above) may handle this in a similar fashion.

answered Oct 04 '15 at 01:49

Brandon White

997
9
22

Thanks Brandon, I am aware of the native PHP solution but I'm looking for a Carbon solution if possible – InvalidSyntax Oct 04 '15 at 01:51
I figured as much, but since I typed it up figured I'd post anyways. Check out Joseph's answer below. – Brandon White Oct 04 '15 at 01:55

Joseph Silber · Accepted Answer · 2015-10-04T01:57:34.220

0

You have to use the createFromFormat method:

$time = Carbon::createFromFormat('H:i:s', '13:00:00')->format('g:iA');

The first argument is the format of the date in your string.

edited Oct 04 '15 at 01:57

answered Oct 04 '15 at 01:39

Joseph Silber

214,931
59
362
292

This returns `2015-10-04 13:00:00` – InvalidSyntax Oct 04 '15 at 01:51
1

I appended your solution with `->format()` and its working as desired – InvalidSyntax Oct 04 '15 at 01:56

How can I format separate date and time variables in Laravel

2 Answers2