I am running the query straight through PSQL so there are no other programs or adapters. The field definition is just 'timestamp'. I did try that as well - no luck :) Rich On 8 Apr 2013, at 14:36, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > On 04/08/2013 06:27 AM, Richard Harley wrote: >> Sure >> >> Timestamp >> 2013/04/08 12:42:40 GMT+1 >> 2013/04/08 12:42:33 GMT+1 >> 2013/04/07 20:25:11 GMT+1 >> 2013/04/07 20:19:52 GMT+1 >> 2013/04/07 20:19:52 GMT+1 > > What program are you using to get the above result? > > What is the field definition for the timestamp column? > > From your previous post try: > > select timestamp from attendance where timestamp = '2012/12/14 12:02:45+0' > >> >> >> Some are GMT, some are GMT+1 depending on when they were entered. >> >> >> >> On 8 Apr 2013, at 14:25, Adrian Klaver <adrian.klaver@xxxxxxxxx >> <mailto:adrian.klaver@xxxxxxxxx>> wrote: >> >>> On 04/08/2013 06:22 AM, Richard Harley wrote: >>>> This doesn't seem to work - take a normal GMT date for example: >>>> 2012/12/14 12:02:45 GMT >>>> >>>> select timestamp from attendance where timestamp = '2012/12/14 12:02:45' >>>> >>>> ..returns nothing >>> >>> Can you show the results of an unconstrained SELECT?: >>> >>> select timestamp from attendance limit 5; >>>> >>>> >>>> >>> >>> >>> -- >>> Adrian Klaver >>> adrian.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx> >> > > > -- > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
