Re: Selecting timestamp from Database

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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com