Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to fetch Timpstamp datatype using OCI layer
On Aug 11, 4:23 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> Rohit wrote:
> > On Aug 10, 2:47 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> > wrote:
> > Rohit wrote:
> >>>> On Aug 9, 1:22 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> >>>> wrote:
> >>>> Also, local settings dictate how your data will be converted:
> >>>> "where t1>=:1" *will* do a conversion - always do your
> >>>> own conversions! Use the to_timestamp function:http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10759/f...
> >>>> I tried both of your suggestions, but I didnt get results.
> >>>> Earlier I was using
> >>>> insert into tstamp9 values(timestamp '2007-08-08 10:00:00.000000000');
> >>>> later on I tried with to_timestamp, but I was having same results.
> >>>> I also tried t1>=:1. But in this case I was not able to fetch data.
> > I fail to see the format mask in use, nor do I see an alter session
> > statement.
>
> > I think for timestamp format mask is default, that is (YEAR-MM-DD
> > HH:MI:SS.FMS)
>
> I think what you think may be one of the sources
> of error. I stated: always do your own conversions, do
> not rely on defaults.
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGvZwqLw8L4IAs830RAu5YAKCQt6VXrZBDW2aIhFbBXyCkVrX77wCgkmeB
> x4YZGs1shbF3pGmdO/RGMPE=
> =f4Rt
> -----END PGP SIGNATURE-----
May be it is some sources conversion error; but same type of
conversion I am doing successfully using my program; I mean I am using
same query in my program too.
so what should be the right conversion to insert a timestamp(9) data
using sql-plus?
Thanks,
Rohit Jain
Received on Sun Aug 12 2007 - 22:46:29 CDT