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

2016-09-21 Thread John R Pierce
On 9/21/2016 8:37 PM, Patrick B wrote: 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

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

2016-09-21 Thread Adrian Klaver
On 09/21/2016 08:37 PM, Patrick B 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

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

2016-09-21 Thread Venkata B Nagothi
On Thu, Sep 22, 2016 at 1:37 PM, Patrick B 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

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

2016-09-21 Thread Ian Barwick
On 22-09-2016 12:37, Patrick B 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: > >

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

2016-09-21 Thread Patrick B
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