Re: How to clone CURRENT_DATE to SYSDATE ?
| От | Emanuel Araújo |
|---|---|
| Тема | Re: How to clone CURRENT_DATE to SYSDATE ? |
| Дата | |
| Msg-id | CAMuTAkanTuDsjwiD5mZcHG2knU8JNDz9bZ1eadeAneiFOw_XNg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to clone CURRENT_DATE to SYSDATE ? (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: How to clone CURRENT_DATE to SYSDATE ?
Re: How to clone CURRENT_DATE to SYSDATE ? |
| Список | 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
Emanuel Araújo
Linux Certified, DBA PostgreSQL
В списке pgsql-general по дате отправления: