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
select * from mytable(at)mydblink;
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