Re: How to clone CURRENT_DATE to SYSDATE ?

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(dot)klaver(at)aklaver(dot)com>:

> 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(dot)post(at)n5(dot)nabble(dot)com
>
>
>>
>> --
>> *Atenciosamente,
>>
>> Emanuel Araújo*
>> */Linux Certified, DBA PostgreSQL
>> /*
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--

*Atenciosamente,Emanuel Araújo*

*Linux Certified, DBA PostgreSQL*