Hi guys,I'm using postgres 9.2 and got the following column:start TIMESTAMP(6) WITHOUT TIME ZONE NOT NULLSELECT 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 column02:40:00 = time columnHow can I do that without modifying any column/data?Maybe in a select?
start TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL
SELECT start FROM test1;
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных