Convert Unix Timestamp to Carbon Object

I have unix timestamp in table, wants to show to user using Carbon. How can I achieve ?

e.g.

1487663764.99256

2017-02-24 23:23:14.654621

Solution 1:

Did you check the carbon docs? I think this is what youre looking for:

Carbon::createFromTimestamp(-1)->toDateTimeString(); 

Checkout http://carbon.nesbot.com/docs/#api-instantiation

Solution 2:

There are several ways to create Carbon instances described in the Carbon documentation, which is linked at the bottom of the project's README. The relevant section is this:

The final two create functions are for working with unix timestamps. The first will create a Carbon instance equal to the given timestamp and will set the timezone as well or default it to the current timezone. The second, createFromTimestampUTC(), is different in that the timezone will remain UTC (GMT). The second acts the same as Carbon::createFromFormat('@'.$timestamp) but I have just made it a little more explicit. Negative timestamps are also allowed.

So you can just do:

$carbon = Carbon::createFromTimestamp($dbResult['SomeTimestampColumn']);