Thread: How to clone CURRENT_DATE to SYSDATE ?

How to clone CURRENT_DATE to SYSDATE ?

From
Emanuel Araújo
Date:
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

Re: How to clone CURRENT_DATE to SYSDATE ?

From
Adrian Klaver
Date:
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


Re: How to clone CURRENT_DATE to SYSDATE ?

From
Emanuel Araújo
Date:
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

Re: How to clone CURRENT_DATE to SYSDATE ?

From
Pavel Stehule
Date:
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-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


Re: How to clone CURRENT_DATE to SYSDATE ?

From
Adrian Klaver
Date:
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