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