Re: Selecting timestamp from Database - Mailing list pgsql-general

From Richard Harley
Subject Re: Selecting timestamp from Database
Date
Msg-id 5AD6CB11-5D84-4A57-BC82-21C7C9F8F9EA@scholarpack.com
Whole thread Raw
In response to Re: Selecting timestamp from Database  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Selecting timestamp from Database
List pgsql-general
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


Some are GMT, some are GMT+1 depending on when they were entered.



On 8 Apr 2013, at 14:25, Adrian Klaver <adrian.klaver@gmail.com> 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@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Selecting timestamp from Database
Next
From: Birta Levente
Date:
Subject: Re: Backup advice