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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
