How to extract hour and minutes from a timestamp

Поиск
Список
Период
Сортировка
От Tan ga
Тема How to extract hour and minutes from a timestamp
Дата
Msg-id 20021017175001.5E5AB47590C@postgresql.org
обсуждение исходный текст
Ответы Re: How to extract hour and minutes from a timestamp  (Andrew McMillan <andrew@catalyst.net.nz>)
Re: How to extract hour and minutes from a timestamp  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-novice
Hi again :)

I already resolver my other problem but now i would like to extract both
time and hour from a timestamp in order to compare with a string.
Ex 2000-01-01 19:30:00
I want the result to be 19:30

With select substr(....) i can do this but that's not what i want.

I'm using python with postgres.
--
10Mb na sua caixa de email gratuita no mail.pt
http://www.mail.pt

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: char() or varchar() for frequently used column
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: How to extract hour and minutes from a timestamp