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