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

[Venkata B Nagothi <nag1010@xxxxxxxxx>]

On Thu, Sep 22, 2016 at 1:37 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:

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?

postgres=# select to_char(start, 'DD-MM-YYYY') from test;

  to_char

------------

 18-12-2015

Regards,

Venkata B N

Fujitsu Australia