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 [EMAIL PROTECTED]; 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
