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()
On 8 Apr 2013, at 14:48, Adrian Klaver <adrian.kla...@gmail.com> wrote: > On 04/08/2013 06:45 AM, Richard Harley wrote: >> I am running the query straight through PSQL so there are no other programs >> or adapters. >> >> The field definition is just 'timestamp'. > > From psql what do you get if you do?: > > \d attendance > >> >> I did try that as well - no luck :) >> >> Rich > > -- > Adrian Klaver > adrian.kla...@gmail.com