Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column

Поиск
Список
Период
Сортировка
От Patrick B
Тема Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column
Дата
Msg-id CAJNY3itr9HrO+2ansEvhgWsozYq=My3HGnOMAQ+AVf82yC-1WA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column  (Ian Barwick <ian@2ndquadrant.com>)
Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column  (Venkata B Nagothi <nag1010@gmail.com>)
Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
Hi guys,

I'm using postgres 9.2 and got the following column:

start TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL

SELECT start FROM test1;

2015-12-18 02:40:00

 I need to split that date into two columns on my select:

2015-12-18 = date column
02:40:00 = time column

How can I do that without modifying any column/data?
Maybe in a select?

Thanks!
Patrick

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column