Re: Selecting timestamp from Database

[Richard Harley <richard@xxxxxxxxxxxxxxx>]

That returns nothings also. But I have spied the problem now:

select  ATTENDANCE.timestamp::text from attendance order by timestamp desc limit 1

return the actual timestamp: 2013-04-08 12:42:40.089952

So the theory I'm wondering about is that the stored data in fact
contains (some values with) fractional seconds, but Richard's
client-side software isn't bothering to show those, misleading him
into entering values that don't actually match the stored data.
Looking at the table directly with psql would prove it one way
or the other.

This is it. It was the psycopg adapter. My bad!!

Thanks Adrian / Tom.

Rich

On 8 Apr 2013, at 14:58, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general