kenshin9
kenshin9

Reputation: 2365

Laravel Timestamp Format / JavaScript Date

I've looked around, but haven't been able to find a clear way of returning Laravel timestamps / datetimes in a particular format. It doesn't really matter to me how it's saved in the database, but when I'm pulling the data, I'd like to format it so that it can be parsed by JavaScript. Does someone know of a good way that doesn't involve having to create multiple accessors?

Edit: To add more detail, I'm actually using AngularJS and would like the date returned in a format so that it can be understood by Angular and its date filter. With the current format, the date filter doesn't work because it can't parse the date, from what I can tell.

Upvotes: 6

Views: 8847

Answers (3)

Peter Kota
Peter Kota

Reputation: 8340

To define an accessor, create a getFooAttribute method on your model where Foo is the "camel" cased name of the column you wish to access. So, you should define an accessor for the test_date (or anything else) attribute. The accessor will automatically be called by Eloquent when attempting to retrieve the value of test_date.

(In the example I'll define it in the User model)

<?php

namespace App;

use Carbon\Carbon;

class User extends Model {
    protected $table = 'users';

    public function getTestDateAttribute($date) {
        //What format do you store in db?
        $storedformat = createFromFormat('Y-m-d H:i:s', $date);
        //What format would you like to show?
        $customformat = $storedformat->format('Y.m.d. H:i:s');
        return $customformat;
    }
}

Then you'll see the following format by default:

$user = User::find(1);
$user->test_date; //2015.11.12. 8:50:20


If you'd like to write simplier code, you should use Traits.

Let's define the DateTrait in App\DateTrait.php file:

<?php

trait DateTrait {
    public function getTestDateAttribute($date) {
        //What format do you store in db?
         $storedformat = createFromFormat('Y-m-d H:i:s', $date);
         //What format would you like to show?
         $customformat = $storedformat->format('Y.m.d. H:i:s');
         return $customformat;
    }
 }

Then use it every model where you'd like to format the test_date column.

<?php

namespace App;

use Carbon\Carbon;

class User extends Model {
    use App\DateTrait;
...
}

Upvotes: 1

odannyc
odannyc

Reputation: 718

In your view just do something like this:

$variable->created_at->format('m-d-y')

Upvotes: 1

James
James

Reputation: 16339

This page here may be useful for getting familiar with Carbon dates and how you can use and format them.

Regarding the parsing of them to a format Javascript can interpret, perhaps you could do something like this - assuming it is coming from an eloquent object you have pulled in to a view or something like that:

{{ (new Carbon\Carbon($dataPassedIn->created_at))->format('F d, Y H:ia') }}

Which would return a date like this September 02, 2015 09:43am, although I'm not sure of the exact format you would need for parsing in to javascript.

Upvotes: 0

Related Questions