| From: | Richard Harley <richard(at)scholarpack(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Selecting timestamp from Database |
| Date: | 2013-04-08 13:27:01 |
| Message-ID: | 5AD6CB11-5D84-4A57-BC82-21C7C9F8F9EA@scholarpack.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Birta Levente | 2013-04-08 13:29:21 | Re: Backup advice |
| Previous Message | Adrian Klaver | 2013-04-08 13:25:12 | Re: Selecting timestamp from Database |