How to set migration for a unix timestamp (in addition to laravel's normal created_at)

You can try this if you want date time string: It Produces something like "2019-03-11 12:25:00"

use Carbon\Carbon; $current_date_time = Carbon::now()->toDateTimeString();

Steps

• Set column type as integer
• Set accessor in eloquent to show you the dates as timestamp !

Migration

$table->integer('created');
$table->integer('reedem_by');

Model.php

protected function getDateFormat()
{
    return 'U';
}

@gitwithravish

cool, does that override the laravel based created_at?

Hi @ddsameera ,

In this particular case Stripe is looking for the unix epoch 017483748937289 style time.

@trevorpan it will do the job for you. I have delt with the same situation in past. This is the easiest approach.

that's great. I couldn't find an exact database https://laravel.com/docs/8.x/migrations#available-column-types column type.

Thank you ~

@gitwithravish

Thanks again for having a look. It got me thinking a little deeper. Hope you can use this:

error: Symfony\Component\ErrorHandler\Error\FatalError Access level to App\Models\Coupon::getDateFormat() must be public (as in class Illuminate\Database\Eloquent\Model)

I found this was less work and more direct:

//Controller
//validation

	$createdUnix = Carbon::now()->timestamp;

//then..

        $coupon = Coupon::create([
        ...
        'created' => $createdUnix,
	...
]);