Styjun

The relationship of noch nicht and the passive voice

What are sources for Magic Items that are not adventure-specific?

Is the name of an interval between two notes unique and absolute?

Intuitive methods for representation of Cartesian Coordinates in terms of Spherical Coordinates as basis

Manager manipulates my leaves, what's in it for him?

Twelve Minesweeper mines that make twelve 4s

Simulate a 1D Game-of-Life-ish Model

What is the maximum viable speed for a projectile within earth's atmosphere?

Did HaShem ever command a Navi (Prophet) to break a law?

EU compensation - fire alarm at the Flight Crew's hotel

Get the encrypted payload from an unencrypted wrapper PDF document

Is there any actual security benefit to restricting foreign IPs?

Regular Expressions with `<` and `?` strange matches

How should I avoid someone patenting technology in my paper/poster?

What was the deeper meaning of Hermione wanting the cloak?

What are the end bytes of *.docx file format

As an employer, can I compel my employees to vote?

Did slaves have slaves?

Why is it called a Blood Knot?

Do the villains know Batman has no superpowers?

Why would a fighter use the afterburner and air brakes at the same time?

Lead Amalgam as a Material for a Sword

Paradox regarding phase transitions in relativistic systems

Should I inform my future product owner that there is a good chance that a team member will leave the company soon?

How to insert into Postgres dateTimeTz with Laravel and Carbon?

Laravel Carbon Data MissingtimestampTz fields in LaravelHow to exit from PostgreSQL command line utility: psqlMultiple Timezoning in Laravel/CarbonLaravel 5 and Carbon discrepancy on ForgeHow can I format separate date and time variables in LaravelCarbon 'InvalidArgumentException' with message 'Trailing data' when overriding $dateFormat attributeLaravel, Carbon, and ValidationsA two digit month could not be found Data missing in Carbon in LaraveldiffForHumans does not work returns me The separation symbol could not CarbonChange created_at value in collection to be carbon human readable

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I want to use the Postgres timstamp with timezone data type.

My migration has this line:

$table->dateTimeTz('local_timestamp');

I try to seed like this:

$note->local_timestamp = Carbon::now();

I have also tried to format it like this when I seed it:

$note->local_timestamp = Carbon::now()->format('Y-m-d H:i:sO');

I retrieve my seeded data like this:

$data = Note::where('owner', $owner)->get();

And I get an InvalidArgumentException "Data missing" in Carbon error that shows this:

at Carbon::rawCreateFromFormat('Y-m-d H:i:sO', '2019-03-28 14:02:42', null)

I have tried including this line in my model because I've seen it suggested as the answer on other similar questions:

protected $dateFormat = 'Y-m-d H:i:sO';

laravel postgresql-9.1 php-carbon

share|improve this question

edited Mar 28 at 14:14

Andy

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

add a comment
 | 

0

I want to use the Postgres timstamp with timezone data type.

My migration has this line:

$table->dateTimeTz('local_timestamp');

I try to seed like this:

$note->local_timestamp = Carbon::now();

I have also tried to format it like this when I seed it:

$note->local_timestamp = Carbon::now()->format('Y-m-d H:i:sO');

I retrieve my seeded data like this:

$data = Note::where('owner', $owner)->get();

And I get an InvalidArgumentException "Data missing" in Carbon error that shows this:

at Carbon::rawCreateFromFormat('Y-m-d H:i:sO', '2019-03-28 14:02:42', null)

I have tried including this line in my model because I've seen it suggested as the answer on other similar questions:

protected $dateFormat = 'Y-m-d H:i:sO';

laravel postgresql-9.1 php-carbon

share|improve this question

edited Mar 28 at 14:14

Andy

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

add a comment
 | 

I want to use the Postgres timstamp with timezone data type.

My migration has this line:

$table->dateTimeTz('local_timestamp');

I try to seed like this:

$note->local_timestamp = Carbon::now();

I have also tried to format it like this when I seed it:

$note->local_timestamp = Carbon::now()->format('Y-m-d H:i:sO');

I retrieve my seeded data like this:

$data = Note::where('owner', $owner)->get();

And I get an InvalidArgumentException "Data missing" in Carbon error that shows this:

at Carbon::rawCreateFromFormat('Y-m-d H:i:sO', '2019-03-28 14:02:42', null)

I have tried including this line in my model because I've seen it suggested as the answer on other similar questions:

protected $dateFormat = 'Y-m-d H:i:sO';

laravel postgresql-9.1 php-carbon

share|improve this question

edited Mar 28 at 14:14

Andy

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

$table->dateTimeTz('local_timestamp');

$note->local_timestamp = Carbon::now();

$note->local_timestamp = Carbon::now()->format('Y-m-d H:i:sO');

$data = Note::where('owner', $owner)->get();

at Carbon::rawCreateFromFormat('Y-m-d H:i:sO', '2019-03-28 14:02:42', null)

protected $dateFormat = 'Y-m-d H:i:sO';

share|improve this question

edited Mar 28 at 14:14

Andy

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

share|improve this question

edited Mar 28 at 14:14

Andy

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

asked Mar 28 at 14:09

AndyAndy

1,3091515 silver badges4040 bronze badges

1 Answer
1

active

oldest

votes

0

Removing the date format from the model fixed the problem.

This answer is very useful - Laravel Carbon Data Missing

I changed the date format based on this answer - timestampTz fields in Laravel - which deals with the timestamptz data type (not datetimetz)

share|improve this answer

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

add a comment
 | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55399649%2fhow-to-insert-into-postgres-datetimetz-with-laravel-and-carbon%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Removing the date format from the model fixed the problem.

This answer is very useful - Laravel Carbon Data Missing

I changed the date format based on this answer - timestampTz fields in Laravel - which deals with the timestamptz data type (not datetimetz)

share|improve this answer

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

add a comment
 | 

0

Removing the date format from the model fixed the problem.

This answer is very useful - Laravel Carbon Data Missing

I changed the date format based on this answer - timestampTz fields in Laravel - which deals with the timestamptz data type (not datetimetz)

share|improve this answer

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

add a comment
 | 

Removing the date format from the model fixed the problem.

This answer is very useful - Laravel Carbon Data Missing

I changed the date format based on this answer - timestampTz fields in Laravel - which deals with the timestamptz data type (not datetimetz)

share|improve this answer

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

share|improve this answer

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges

answered Mar 28 at 14:24

AndyAndy

1,3091515 silver badges4040 bronze badges