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

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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Selecting timestamp from Database
Следующее
От: Birta Levente
Дата:
Сообщение: Re: Backup advice