Re: Selecting timestamp from Database
| От | Richard Harley |
|---|---|
| Тема | Re: Selecting timestamp from Database |
| Дата | |
| Msg-id | 5AD6CB11-5D84-4A57-BC82-21C7C9F8F9EA@scholarpack.com обсуждение исходный текст |
| Ответ на | Re: Selecting timestamp from Database (Adrian Klaver <adrian.klaver@gmail.com>) |
| Ответы |
Re: Selecting timestamp from Database
|
| Список | pgsql-general |
Sure
Some are GMT, some are GMT+1 depending on when they were entered.
| 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 по дате отправления: