Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On 04/08/2013 06:03 AM, Richard Harley wrote:Hello allPretty sure this should be simple - how can I select a timestamp from adatabase?The timestamp is stored in the db like this:2013/04/08 13:54:41 GMT+1How can I select based on that timestamp?At the simplest level "select timestamp from attendance where timestamp= '2013/04/08 13:54:41 GMT+1'"..doesn't obviously work but I've tried all sorts of to_char andto_timestamp combos to no avail..Any ideas?select timestamp from attendance where timestamp = '2013/04/08 13:54:41+1'CheersRich-- Adrian Klaveradrian.klaver@gmail.com-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
Hello allPretty sure this should be simple - how can I select a timestamp from adatabase?The timestamp is stored in the db like this:2013/04/08 13:54:41 GMT+1How can I select based on that timestamp?At the simplest level "select timestamp from attendance where timestamp= '2013/04/08 13:54:41 GMT+1'"..doesn't obviously work but I've tried all sorts of to_char andto_timestamp combos to no avail..Any ideas?
CheersRich
В списке pgsql-general по дате отправления: