Re: Selecting timestamp from Database

[Richard Harley <richard@xxxxxxxxxxxxxxx>]

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.klaver@xxxxxxxxx> 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.klaver@xxxxxxxxx