On 04/08/2013 06:49 AM, Richard Harley wrote:
It's
Column | Type |
Modifiers
--------------+-----------------------------+-------------------------------------------------------------------
attendanceid | integer | not null default
nextval('attendance_attendanceid_seq'::regclass)
entered | date | not null default
('now'::text)::date
timeperiod | character(2) |
timestamp | timestamp without time zone | default now()
Well timestamp is not time zone aware, so I have no idea where your time
zone offsets are coming from.
What happens if you do:
"select timestamp from attendance where timestamp = ' '2012-12-14 12:02:45';
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
