On Thu, Sep 22, 2016 at 1:37 PM, Patrick B <patrickbake...@gmail.com> 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
