Timestamp functions not returning time

Question

I'm using Postgresql 9.6 and pgAdmin 4. Fresh install on both Windows and Mac, happens on both.

I need to store the current time and date.

None of my timestamp functions are returning times.

Time and Date work fine

SELECT CURRENT_DATE

Output: 2016-07-15

SELECT CURRENT_TIME

Output: 14:27:22.333352+01:00

SELECT CURRENT_TIMESTAMP

Output: 2016-07-15T00:00:00Z

Expected: 2016-07-15T14:27:22+01:00

SELECT now()

Output: 2016-07-15T00:00:00Z

Expected: 2016-07-15T14:27:22+01:00

What is the problem here?

You guys are right. I tested on windows and it works with psql. Is there a way around this or is it just an accepted limitation? — MercilessMaverick, Jul 15 '16 at 14:01
Seems it is just a display error. The correct values are shown in psql — MercilessMaverick, Jul 15 '16 at 14:15

score 0 · Answer 1 · answered Jul 15 '16 at 13:43

0

set timezone TO 'GMT';

SET TIME ZONE 'UTC';

OR

You can set timezone param into pgsql/data/postgresql.conf file:

timezone = 'US/Central'

and then restart postgresql sever.

answered Jul 15 '16 at 13:43

rajeev

115
8

score 0 · Answer 2 · answered Jul 15 '16 at 14:14

0

The problem is a bug in pgAdmin 4.

Timestamps are displayed incorrectly with the time set to 00:00:00Z The data is stored correctly and the correct time can be observed using a different a different client such as psql

answered Jul 15 '16 at 14:14

MercilessMaverick

257
2
12

score 0 · Answer 3 · answered Oct 05 '16 at 08:40

0

This issue has been resolved with newer version of pgAdmin4.

answered Oct 05 '16 at 08:40

Murtuza Z

5,639
1
28
52

Timestamp functions not returning time

3 Answers3