Home > mailing lists

Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column - Mailing list pgsql-general

From	Patrick B
Subject	Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column
Date	September 22, 2016 03:38:11
Msg-id	CAJNY3itr9HrO+2ansEvhgWsozYq=My3HGnOMAQ+AVf82yC-1WA@mail.gmail.com Whole thread Raw
Responses	Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column
List	pgsql-general

Tree view

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 by date:

From: Jeff Janes
Date: 22 September 2016, 02:43:57
Subject: Re: Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

From: Ian Barwick
Date: 22 September 2016, 03:51:10
Subject: Re: Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column

Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column - Mailing list pgsql-general

Previous

Next