Re: Selecting timestamp from Database

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@gmail.com