Thank's Adrian,
I want really create another CURRENT_DATE called SYSDATE.
postgres=# SELECT CURRENT_DATE ;
date
------------
2014-09-25
(1 row)
I need that:
postgres=# SELECT SYSDATE ;
date
------------
2014-09-25
Because, I am trying SymmetricDS between Oracle and PostgreSQL, in my case, there are a lot of fields with "DEFAULT trunc(sysdate)". This situation break when I start the sincronization why the data type there isn't in PostgreSQL.
2014-09-24 16:43 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 09/24/2014 07:39 AM, Emanuel Araújo wrote:
Hi,
I need to clone function CURRENT_DATE to SYSDATE in my PostgreSQL.
Does anybody know how to do that it ?
Not sure what you want?
A clone is an exact replica so cloning CURRENT_DATE would create another CURRENT_DATE. My guess is that this not what you want.
So do you want to create SYSDATE in Postgres?
If so, look at this thread for the issues:
http://www.postgresql.org/message-id/1409288790481-5816851.post@xxxxxxxxxxxxx
--
*Atenciosamente,
Emanuel Araújo*
*/Linux Certified, DBA PostgreSQL
/*
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
Atenciosamente,
Emanuel Araújo
Linux Certified, DBA PostgreSQL
Emanuel Araújo
Linux Certified, DBA PostgreSQL
