Thread: How to clone CURRENT_DATE to SYSDATE ?
Hi,
--
I need to clone function CURRENT_DATE to SYSDATE in my PostgreSQL.
Does anybody know how to do that it ?
Atenciosamente,
Emanuel Araújo
Linux Certified, DBA PostgreSQL
Emanuel Araújo
Linux Certified, DBA PostgreSQL
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
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
Emanuel Araújo
Linux Certified, DBA PostgreSQL
Hi
2014-09-25 12:24 GMT+02:00 Emanuel Araújo <eacshm@gmail.com>:
Thank's Adrian,I want really create another CURRENT_DATE called SYSDATE.
It needs a hack to postgres. Pseudoconstant functions needs a support in PostgreSQL parser. There is no other possibility
Pavel
postgres=# SELECT CURRENT_DATE ;date------------2014-09-25(1 row)I need that:postgres=# SELECT SYSDATE ;date------------2014-09-25Because, 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
On 09/25/2014 03:24 AM, Emanuel Araújo wrote: > 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. Best guess is the answer lies here: http://www.symmetricds.org/doc/3.6/user-guide/html/config.html#configuration-transforms > -- Adrian Klaver adrian.klaver@aklaver.com