On 04/08/2013 06:49 AM, Richard Harley wrote:
It'sColumn | 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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
