Re: Selecting timestamp from Database

[Richard Harley <richard@xxxxxxxxxxxxxxx>]

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