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