Re: Selecting timestamp from Database

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Richard Harley <richard(at)scholarpack(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Selecting timestamp from Database
Date: 2013-04-08 13:25:12
Message-ID: 5162C538.5030601@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Harley 2013-04-08 13:27:01 Re: Selecting timestamp from Database
Previous Message Richard Harley 2013-04-08 13:22:25 Re: Selecting timestamp from Database