Re: How to clone CURRENT_DATE to SYSDATE ? - Mailing list pgsql-general

From Emanuel Araújo
Subject Re: How to clone CURRENT_DATE to SYSDATE ?
Date
Msg-id CAMuTAkanTuDsjwiD5mZcHG2knU8JNDz9bZ1eadeAneiFOw_XNg@mail.gmail.com
Whole thread Raw
In response to Re: How to clone CURRENT_DATE to SYSDATE ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to clone CURRENT_DATE to SYSDATE ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: How to clone CURRENT_DATE to SYSDATE ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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@aklaver.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.post@n5.nabble.com



--
*Atenciosamente,

Emanuel Araújo*
*/Linux Certified, DBA PostgreSQL
/*


--
Adrian Klaver
adrian.klaver@aklaver.com



--
Atenciosamente,

Emanuel Araújo

Linux Certified, DBA PostgreSQL

pgsql-general by date:

Previous
From: Andrej Vanek
Date:
Subject: Re: deadlock of lock-waits (on transaction and on tuple) using same update statement
Next
From: Pavel Stehule
Date:
Subject: Re: How to clone CURRENT_DATE to SYSDATE ?