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 ?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: How to clone CURRENT_DATE to SYSDATE ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrej Vanek
Дата:
Сообщение: Re: deadlock of lock-waits (on transaction and on tuple) using same update statement
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How to clone CURRENT_DATE to SYSDATE ?