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 <[email protected]>:
> 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-
> [email protected]
>
>
>>
>> --
>> *Atenciosamente,
>>
>> Emanuel Araújo*
>> */Linux Certified, DBA PostgreSQL
>> /*
>>
>
>
> --
> Adrian Klaver
> [email protected]
>
--
*Atenciosamente,Emanuel Araújo*
*Linux Certified, DBA PostgreSQL*
