PostgreSQL: insert sql statement with default timestamp - dbeaver vs php

Question

Given this simple table:

create table comments (
  id numeric not null,
  comment text, 
  created timestamp not null default now()
);

Using dbeaver directly on the db from my pc, and executing this statement

insert into comments (id, comment)
select 1111, 'test';

the "created" field of the new record is: 2017-02-24 16:17:21 and that's my correct time (CET).

When I run the very same statement from a php script (running on a linux-based webserver connected to the db), the result is 2017-02-24 15:17:21. The linux server time is ok (that is, CET).

What am I missing?

In your PHP ini file, check the selected timezone. EDIT: Actually not quite sure why this would matter — Andy
– Andy, Commented Feb 24, 2017 at 15:39
@Andy I already tried to set date_default_timezone_set('CET'); — Giovanni Formentini
– Giovanni Formentini, Commented Feb 24, 2017 at 16:03
Have you tried this? stackoverflow.com/questions/16609724/… — Andy
– Andy, Commented Feb 24, 2017 at 19:15

Community · Accepted Answer · 2017-05-23 12:25:08Z

0

As per the answer at this link, change your table definition to

create table comments (
   id numeric not null,
   comment text, 
   created timestamp not null default (now() at time zone ('CET'))
);

which will use the current datetime using the desired time zone.

edited May 23, 2017 at 12:25

CommunityBot

11 silver badge

answered Feb 27, 2017 at 14:18

Andy

69812 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: insert sql statement with default timestamp - dbeaver vs php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related