Re: Extracting time from timestamp

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Extracting time from timestamp
Дата
Msg-id 200303210859.39903.shridhar_daithankar@persistent.co.in
обсуждение исходный текст
Ответ на Extracting time from timestamp  ("Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
On Friday 21 Mar 2003 12:04 am, Darren Ferguson wrote:
> If the field is definately a timestamp field just do the following
>
> SELECT TO_CHAR(stime,'HH24:MI') FROM bookings;

Problem is I want timestamp out of it, not char. representation because I have
to compare quite a few of them. That's where I am stuck..

 Shridhar

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

Предыдущее
От: "Thomas T. Thai"
Дата:
Сообщение: Re: TSearch Related? - ERROR: datumGetSize: Invalid typLen
Следующее
От: "Thomas T. Thai"
Дата:
Сообщение: pg_restore and adding a column