From: | sachin kotwal <kotsachin(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Migration from DB2 to PostgreSQL |
Date: | 2013-06-19 08:24:30 |
Message-ID: | 1371630270831-5759820.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
While migrating my application from DB2 to PostgreSQL.
I want to migrate following functions in PostgreSQL.
TO_CHAR() in DB2 which can take three arguments as follows:
SELECT TO_CHAR(CURRENT_DATE,'YYYY-MM-DD',112.50) FROM SYSIBM.SYSDUMMY1
I am not sure what is the purpose of third argument in TO_CHAR() function of
DB2.
I think we can create one user define function with name TO_CHAR which can
take three argument like DB2.
I want to know that if we want to create user define function TO_CHAR().
What should be the data type of third argument?
which can handle maximum data types and more suitable for real time
scenarios.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-tp5759820.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | sachin kotwal | 2013-06-19 08:56:23 | Migration from DB2 to PostgreSQL-ROLLUP() |
Previous Message | bhanu udaya | 2013-06-19 07:12:13 | Re: [GENERAL] Postgres DB crashing |