----=_vm_0011_W6447414777_12610_1211065120
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
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@[EMAIL PROTECTED]
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
----=_vm_0011_W6447414777_12610_1211065120
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
<html><body bgcolor=3D"#ffffff"><DIV><FONT face=3DVerdana size=3D2>Hi,</=
FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I am accessing data across different databases using =
dblinks but the dates are getting messed up:</FONT></DIV>
<DIV><FONT size=3D2>table: mytable</FONT></DIV>
<DIV><FONT size=3D2>columns: my_id &nb=
sp; int</FONT></DIV>
<DIV> &n=
bsp; <FONT size=3D2>my_date  =
;date</FONT></DIV>
<DIV><FONT size=3D2>values: 1</FONT></DIV>
<DIV> &n=
bsp; <FONT size=3D2>2008-04-09</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>When retrieving data from the table in the relev=
ant database the date is returned correctly: 2008-04-09</FONT></DIV>
<DIV><FONT size=3D2>but when retrieving across dblinks using statement be=
low, I get the following error:</FONT></DIV>
<DIV><FONT size=3D2>statement looks like</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>select * from <A href=3D"mailto:mytable@[EMAIL PROTECTED]
">myt=
able@[EMAIL PROTECTED]
>;</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>the error refers to the datestyle setting and shows t=
he date as '2008-09-04'</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Please advise if there is a way around this.</FONT></=
DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks,</FONT></DIV>
<DIV><FONT size=3D2>Sumaya</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV></body></html>
----=_vm_0011_W6447414777_12610_1211065120--
