Re: Constructors for dates, times, and timestamps

Поиск
Список
Период
Сортировка
От Andrew T. Robinson
Тема Re: Constructors for dates, times, and timestamps
Дата
Msg-id 45E73E73.3090906@nmi.net
обсуждение исходный текст
Ответ на Re: Constructors for dates, times, and timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Thanks for the pointers.  I did figure out

    'yyyy-mm-dd'::date
    'hh:mm:ss'::time

And I also came up with

    (date_column::text || ' ' || time_column::text)::timestamp

Which is too ugly for words.  I appreciate the more elegant solutions
posted to the list.

I'm growing to like Postgres, but I'm not sure I'll ever get over DB/2 :-)

Andy

Вложения

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