Problem with datatime filed
Posted: Mon 03 Nov 2008 15:32
Hi
I have problem with reading from datatime filed. For example, when I have table like this
CREATE TABLE test (
din timestamp
);
SELECT * FROM test always return year 2000-01-01 00:00. In my log file from postgres I get
2008-11-03 16:09:42 [27047] LOG: connection received: host=192.168.10.71 port=2949
2008-11-03 16:09:42 [27047] LOG: connection authorized: user=postgres database=velvet
2008-11-03 16:09:42 [27047] LOG: statement: SELECT version()
2008-11-03 16:09:42 [27047] LOG: statement: show integer_datetimes
2008-11-03 16:09:42 [27047] ERROR: unrecognized configuration parameter "integer_datetimes"
2008-11-03 16:09:42 [27047] LOG: statement: SET autocommit=true
2008-11-03 16:09:42 [27047] LOG: statement: SET datestyle=ISO
My Postgres version is
velvet=# SELECT version();
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.17 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)
It look like commponenet discover wrong postgres version.
BTW.
I have commponenet for mobile devices I they work this same.
Best regards
marlin
I have problem with reading from datatime filed. For example, when I have table like this
CREATE TABLE test (
din timestamp
);
SELECT * FROM test always return year 2000-01-01 00:00. In my log file from postgres I get
2008-11-03 16:09:42 [27047] LOG: connection received: host=192.168.10.71 port=2949
2008-11-03 16:09:42 [27047] LOG: connection authorized: user=postgres database=velvet
2008-11-03 16:09:42 [27047] LOG: statement: SELECT version()
2008-11-03 16:09:42 [27047] LOG: statement: show integer_datetimes
2008-11-03 16:09:42 [27047] ERROR: unrecognized configuration parameter "integer_datetimes"
2008-11-03 16:09:42 [27047] LOG: statement: SET autocommit=true
2008-11-03 16:09:42 [27047] LOG: statement: SET datestyle=ISO
My Postgres version is
velvet=# SELECT version();
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.17 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)
It look like commponenet discover wrong postgres version.
BTW.
I have commponenet for mobile devices I they work this same.
Best regards
marlin