dblinks

Поиск

Список

Период

Сортировка

От	sumaya@silvermoongroup.com
Тема	dblinks
Дата	17 мая 2008 г. 19:58:45
Msg-id	W6447414777126101211065120@webmail12 обсуждение исходный текст
Ответы	Re: dblinks
Список	pgsql-sql

Hi,

I am accessing data across different databases using dblinks but the dates are getting messed up:

table: mytable

columns: my_id int

my_date date

values: 1

2008-04-09

When retrieving data from the table in the relevant database the date is returned correctly: 2008-04-09

but when retrieving across dblinks using statement below, I get the following error:

statement looks like

the error refers to the datestyle setting and shows the date as '2008-09-04'

Please advise if there is a way around this.

Thanks,

Sumaya

В списке pgsql-sql по дате отправления: