Re: Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)

Using your link
http://www.postgresql.org/docs/9.2/static/functions-formatting.html

In DB2 when I use following command I am getting output combined date and
time i passed to function.

#SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1

1
--------------------------
2013-01-01-12.13.14.000000

1 record(s) selected.
==========================

If I execute same command with TO_TIMESTAMP() function I am getting default
date.

SELECT TO_TIMESTAMP('2013-01-01','12:13:14');
to_timestamp
---------------------------------
0001-01-01 00:00:00+05:53:28 BC
(1 row)

So output is different, so I can not use TO_TIMESTAMP() function as it is.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-TIMESTAMP-arg1-arg1-tp5761389p5761626.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.